How to find duplicate rows in a huge excel file containing 500000 rows

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to find duplicate rows in a huge excel file containing 500000 rows

FAQ

Thread Tools

Display Modes

06-22-2017, 07:47 AM

Stc25234

Windows 7 64bit How to find duplicate rows in a huge excel file containing 500000 rows

Office 2003

Novice

Join Date: Jun 2017

Posts: 1

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge duplicate rows but retain data from one column	Willem113	Excel	1	09-21-2016 05:42 PM
Excel Newbie Question: .dbf file import help - 1 mil+ rows	LisaExcelHelp	Excel	1	01-26-2015 07:39 AM
Huge table needs to link rows and column in a special manner (when not equal to 0)	melieetnala	Excel	1	08-12-2014 05:56 AM
Macro to Delete Duplicate Rows and Retain Unique Value	expert4knowledge	Excel Programming	1	02-17-2014 08:02 PM
Find Results in excel copy the rows to another sheet	khalidfazeli	Excel	2	02-06-2013 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 PM.