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 well for me as I have 30,000 lines to eyeball the duplicates. Is there another way to find the duplicates? Thanks.
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.
