seardhing for duplicate cells in a cloumn

D

Don

How do you search for duplicate cells in a column other
than sorting on the column and physically viewing each
page. Can this be done with a macro or formula?
 
G

Guest

Gord,
I can't get the formula to work. What am I doing wrong?
I have a column (b2 to b17430) that I would like to
identify and highlight "any" duplicate cells. I don't
understand the >1 part of the formula either!
Thanks,
Don
 

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

Cell data entering slow! 0
Copy addition formula of non-consecutive horizontal cells 2
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Consolidation Table from Different Excel Tabs with Different Format 1
Count Values in a Range, Not Formulas 2
Finding Duplicate Rows & Highlighting them 6
searching columns for the same value 1

Top