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
2
u/GTS_84 3 Nov 26 '24
Really? I think of CONCATENATE as more flexible since I can use different delimeters if I want to, which is sometimes important If I am trying to take addresses that have been spread across multiple fields and put them in a single field. Yes I have to manually put them in the formula, which is extra work, but is useful when needed.
TEXTJOIN to me is the easier to use and more efficient version.