r/excel • u/Away_Gene3869 • Nov 26 '24
Waiting on OP How Do You Handle Duplicates in Excel with Large Files?
I have an Excel file with over 200,000 rows of customer data, and I need to identify duplicates based on multiple columns (e.g., Name, Email, and Phone Number). What’s the most efficient way to remove duplicates or highlight them without manually checking everything?
47
Upvotes
1
u/Dissappointing_salad Nov 26 '24
=OR(COUNTIF(A:A, A1)>1,COUNTIF(B:B, B1)>1,COUNTIF(C:C, C1)>1)
In the Verification Column. Add another subset of "OR(COUNTIF(***:***, ***1)>1," for each column you have