Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-19-2005, 03:04 PM
Novice
 
Join Date: Nov 2005
Posts: 1
aleccamp
Default Creating a Map From a List of Addresses


I have found a solution to convert a list of IP addresses into locations - City and State. What I would like to do with the list is the following:

1. Remove all duplicate references (as the raw data comes from a log file, there are multiple instances of the same IP address)

2. Calculate the number of unique text references (e.g. sum the number of cells with New York or Philadelphia) in each column

3. Create a visitor map showing the location and density of visitors

Easy eh? Can anyone help point me to a solution? Free or Paid - either works.

Thanks,
ADC
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook e-mail addresses Export to a CSV file ronb Outlook 1 03-24-2009 07:45 AM
Duplicate Emails (Scrub Email Addresses) zinfandel72 Outlook 0 08-03-2008 12:23 PM
Creating a Distrubution List from Excel webphotogeek Outlook 0 01-10-2008 11:21 AM
creating a categories list owwiii Outlook 0 08-09-2007 01:56 PM
deleting archived addresses pacificdon Outlook 0 12-12-2005 03:39 PM


All times are GMT -7. The time now is 06:35 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft