seardhing for duplicate cells in a cloumn

  • Thread starter Thread starter Don
  • Start date Start date
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?
 
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
 
Back
Top