LinkBack URL
About LinkBacks
Hi all,
What is the easiest way to find if there are any duplicates in a column?
Thank you!
Hi all,
What is the easiest way to find if there are any duplicates in a column?
Thank you!
Conditional Formatting > Highlight cells rules > duplicated values
Many ways to skin that cat:
in column B and drag down.
=IF(COUNTIF(A:A,A1)>1,"Duplicate","")
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Another approach... if you only want to highlight the duplicates and leave the original unique entry you can use something like this:
in cell B1 and drag down.=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","")
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks