how do i find duplicate cells in excel

[Paul]

Hi

I have a column of IP addresses and need to search them to find out if any
are duplicates.

BR
Paul

 

[Dave Peterson]

You may want to look at Chip Pearson's site. He has lots of techniques to work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

 

[FSt1]

hi
see this site
http://cpearson.com/excel/Duplicates.aspx

regards
FSt1

 

[GD]

If you are using Excel 2007, you simply highlight the column then click
Conditional Formatting, Highlight Cell Rules, Duplicate Values.