Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2005, 03:04 PM
aleccamp aleccamp is offline
Novice
Creating a Map From a List of Addresses
 
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft