Forum Discussion
Finding duplicates in a large excel sheet
I agree with using the conditional formatting to highlight all duplicates. From there you can create a new Helper column and input a 1 for all rows that show up in the filter to make it easier to identify all rows that are duplicates.
1. Conditional Format
2. Filter by Color
3. Helper Column
rkozak Can you tell me what step you're lost in? The breakdown before with screenshots should cover all the steps
I believe I understand what you're doing; you click the dropdown box where you can select variables to be included in your filter/sort for that given column. It is there that I can see filter by colour. I have tried this on another smaller list and it works easily.
Unfortunately, due to the sheer size of the file my computer always freezes and is unable to process even opening the drop down box because we have 109,749 unique values in that column. These are where the duplicate values are the utmost of importance because they actually correspond to serial numbers we intend to use.