removing duplicates from a list

  • Thread starter Thread starter aleccamp
  • Start date Start date
A

aleccamp

I have a list of IP addresses of visitors to my website. I want to
remove the duplicates so that only a unique list remains. Can anyone
point me to a solution?

Thanks,
ADC
 
Thanks Gord. Would you know if it's possible to filter entire rows vs
just one column? I have 4 columns and need to filter by column A
only.

Cheers,
Alec
 
Hi!

If column A contains the IP addresses and your data is in the range A1:D100:

Use a helper column, column E, and enter this formula in E1:

=IF(COUNTIF(A$1:A1,A1)=1,"X","")

Copy down to E100.

This will place a "X" in cells that correspond to the unique values in
column A.

Then you can just use an AutoFilter and filter on "X" in column E.

Biff
 
Alec

Filtering on one column will filter entire rows.

Try it and you will see, unless I misunderstand your concern.


Gord
 
Back
Top