Find Duplicates in a column

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

How do I find the duplicates in a column of data? Boy I'd
love to know.
thanks
 
Greg

one way is to use conditional formatting. Assume you want to check column
C. Select the whole column and choose Format | Conditional Formatting ...

Change the Condition to "Formula is" and enter: =COUNTIF(C:C,C1)>1 into the
box. Change the font or the background to a suitable highlight colour and
press OK.

Wherever/whenever you have a duplicate entry it will change colour

Regards

Trevor
 
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

Augmenting an integer in a column to reflect duplicates in another 23
How to filter Unique values from Duplicates 6
Finding duplicates 2
Duplicates formula 5
Finding duplicate cells within a worksheet automatically 1
Duplicate data entries 1
Not just remove dup rows but combine columns 1
Excel Comparing two columns 1

Back
Top