Forum Discussion
Eli_Cohen830
Feb 01, 2024Copper Contributor
How to clear unique values and stay with duplicates?
Hi I have a sheet with 100,000+ rows and some of them are duplicates that I need to identify and delete from the system how would i do it?
Sergiusz
Feb 01, 2024Copper Contributor
Hi, Eli_Cohen830,
1. The easiest way is to use the "Remove duplicates" button in the "Data" menu.
2. To view duplicate values, you can use the dedicated "Show duplicates" button in the "Conditional formatting" menu.
I recommend - above buttons add to the Quick Access Toolbar, e.g. like mine:
Regards,
Sergiusz