SOLVED

Excel - How do find duplicates (without removing) from a large database? Hide unique values?

Copper Contributor

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.

 

3 Replies
best response confirmed by WMGoh (Copper Contributor)
Solution

@WMGoh 

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.

1 best response

Accepted Solutions
best response confirmed by WMGoh (Copper Contributor)
Solution

@WMGoh 

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.

View solution in original post