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


--
aleccamp
------------------------------------------------------------------------
aleccamp's Profile: http://www.excelforum.com/member.php...o&userid=28913
View this thread: http://www.excelforum.com/showthread...hreadid=486574

ADV

DataFilterAdvanced 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/xladvfi...html#ExtractWs


Gord Dibben Excel MVP

On Sat, 19 Nov 2005 15:57:24 -0600, aleccamp
wrote:


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


--
aleccamp
------------------------------------------------------------------------
aleccamp's Profile: http://www.excelforum.com/member.php...o&userid=28913
View this thread: http://www.excelforum.com/showthread...hreadid=486574

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

"aleccamp" wrote in
message ...

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


--
aleccamp
------------------------------------------------------------------------
aleccamp's Profile:
http://www.excelforum.com/member.php...o&userid=28913
View this thread: http://www.excelforum.com/showthread...hreadid=486574

Alec

Filtering on one column will filter entire rows.

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


Gord

On Sat, 19 Nov 2005 17:34:20 -0600, aleccamp
wrote:


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