removing duplicates from a list

[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

 

[Gord Dibben]

ADV

Data>Filter>Advanced Filter.

Check "unique records only" and "copy to another location".

To copy to another worksheet see Debra's instructions at

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs


Gord Dibben Excel MVP

 

[aleccamp]

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

 

[Biff]

Hi!

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

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

 

[Gord Dibben]

Alec

Filtering on one column will filter entire rows.

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


Gord