Jul 12 2021 06:26 AM
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.
Jul 12 2021 06:40 AM
SolutionYou 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.
Jul 12 2021 06:45 PM
Jul 13 2021 02:13 AM
@WMGoh , you are welcome
Jul 12 2021 06:40 AM
SolutionYou 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.