how do i find duplicate cells in excel

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hi

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

BR
Paul
 
If you are using Excel 2007, you simply highlight the column then click
Conditional Formatting, Highlight Cell Rules, Duplicate Values.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
Entire Row Duplicates 6
remove duplicates but retain one not delete both 4
Eliminating duplicates 2
Removing Duplicates to another sheet 1
check for duplicates 10
How do I merge duplicated data in rows with different criteria 1
Finding Duplicate Cell Entries 6

Back
Top