Best Way to Deduplicate Records but leave one

jscranton

Well-known Member
Joined
May 30, 2011
Messages
707
I have an extremely large table (4.8MM records) that is the result of users importing excels with the same format into this table. From what I can tell, there are a significant number of duplicates within this population (likely from users importing the same excel twice). The tricky part is that I want to remove duplicates where all fields are the same but leave at least one record. In Excel, I would just concatenate all the fields into a new column and then deduplicate the table on that concatenated field. Is there a way to do this in access?

Thanks,

J
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,569
Office Version
2019
Platform
Windows
It would create a query result that only lists unique rows. If you then need that somewhere else, you could do a MakeTable query, export to Excel, include in a report, etc. which only have the unique information.
 

jscranton

Well-known Member
Joined
May 30, 2011
Messages
707
Thanks. The problem is that even deduplicated it is over 2MM rows. I ended up building a new table and appending the uniques to it.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,134
Messages
5,466,869
Members
406,506
Latest member
Patb3

This Week's Hot Topics

Top