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