how do i find duplicate cells in excel
 

Hi

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

BR
Paul

how do i find duplicate cells in excel
 

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

Paul wrote:

Hi

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

BR
Paul

--

Dave Peterson

how do i find duplicate cells in excel
 

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

regards
FSt1

"Paul" wrote:

Hi

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

BR
Paul

how do i find duplicate cells in excel
 

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

"Paul" wrote:

Hi

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

BR
Paul