Forum Discussion
Solved
Excel - How do find duplicates (without removing) from a large database? Hide unique values?
I have a huge database that I need to check for duplicates. Understand that one of the way is using conditional formatting to highlight the field (in different colours), however this doesn't work wel...
You may use helper column to filter duplicates/unique values. If you are on Excel 365 you may use =COUNTIFS(range, range), if not =COUNTIFS(range, cell) and Ctrl+D it down.
Values >1 in this column indicate duplicates, use filter on all but 1.
Brilliant! Thanks.
WMGoh , you are welcome