Forum Discussion
Solved
Finding duplicates in a large excel sheet
I have a very large spreadsheet of approximately 316,000 rows. I have used the conditional formatting tool to help me find duplicates. My next step is to use the find tool and search for the duplicat...
You just want to highlight the duplicated rows or remove them.
To remove the duplicated rows, from Data tab --> Data tools --> click Removed duplicates.
To just find the duplicated rows, you can used vlookup function
To remove the duplicated rows, from Data tab --> Data tools --> click Removed duplicates.
To just find the duplicated rows, you can used vlookup function
Jihad Al-Jarady I can't remove the duplicate rows, they provide necessary information that will be used to review another application. My goal is to quickly find them.
