Forum Discussion
Finding duplicates in a large excel sheet
HansVogelaar I tried that in the formatting from the duplicate tool does not apply to the cells it basically overlays the color onto the cell. If I manually apply the color to the cell then the find tool works only on the one that I manually apply the color. The find tool skips over any color that is applied by the find duplicate tool. I hope that makes sense.
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.
