how do you identify duplicates in a spreadsheet? I don't want to remove them.
how do you identify duplicates in a spreadsheet? I don't want to remove them.
You can highlight them with conditional formatting
Conditional formula: =COUNTIF(A:A,A1)>1
You can identify with a TRUE/FALSE flag in a column adjacent.
formula: =COUNTIF(A:A,A1)>1
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
or you could use advanced filter, depends on your layout, also in excel 2007 there is an option to do that as well
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I have a similar macro, give this a shot:
Please Login or Register to view this content.
This looks up column A, and highlights duplicates in grey. So if you have value in cell A23 and A54 that are the same, both will be highlighted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks