Forum Discussion
Finding duplicates in a large excel sheet
After applying conditional formatting to highlight duplicates, you can turn on Filter, then select Filter by Color to select only the duplicates.
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
