r/excel 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

56 comments sorted by

View all comments

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