Find Duplicates in a column

T

Trevor Shuttleworth

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
 

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

Repeated phrases wildcard? 1
Copy addition formula of non-consecutive horizontal cells 2
Finding Duplicate Rows & Highlighting them 6
Duplicate entry in a column/row 14
I'm John, My first post. 0
Removing a repeated words 0
Swap text 2
If, Or, and 5

Top