Thread: How to find duplicate rows in a huge excel file containing 500000 rows
View Single Post
 
Old 06-22-2017, 07:47 AM
Stc25234 Stc25234 is offline Windows 7 64bit Office 2003
Novice
  
Join Date: Jun 2017
Posts: 1
Stc25234 is on a distinguished road
Default How to find duplicate rows in a huge excel file containing 500000 rows
Hi,
I am working on finding duplicates in an excel file that contains 545000 rows.
I have tried the conditional formatting method, it runs for more than an hour.
Now I am trying with Countif and this also is taking more than an hour.
Is there a quicker way to find duplicates in a large excel file?
Reply With Quote