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