Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Reply With Quote

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 09:39 AM.

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. is not affiliated with Microsoft