Stop Using Remove Duplicates — Try This Instead

Most Excel tutorials tell you to use Data > Remove Duplicates and call it a day. They’re wrong. That button doesn’t deduplicate—it deletes. And once those rows vanish, you can’t tell which one stayed or why. Worse? It ignores context: same name + different email? Same ID + different status? Remove Duplicates treats them as identical and nukes one at random. (Trust me—I lost three hours reconciling payroll because of this.)

Remove Duplicates vs UNIQUE + FILTER

Criterion	Remove Duplicates	UNIQUE + FILTER
Preserves original order	✅ Yes (but only if you sort first)	✅ Yes—by default
Shows which rows were kept	❌ No—just says "X duplicates removed"	✅ Yes—you see every result in real time
Handles partial matches	❌ Only full-row matches	✅ Yes—e.g., keep first occurrence per Email, ignore Name
Non-destructive	❌ Deletes rows permanently	✅ Writes to new location—original stays intact
Works with dynamic arrays	❌ Static only	✅ Fully dynamic—updates when source changes
Keyboard shortcut	Alt + A → M → D	Alt + = (to open Formula Bar), then type =UNIQUE(…)

When to Use Remove Duplicates

You should only use Remove Duplicates when you’re certain all columns matter—and you’ve already validated the data. For example: cleaning up a raw export from a survey tool where every field is required and identical rows truly mean accidental double-submission.

Try it on this range: A1:E12, where each row is a completed form entry:

ID	Name	Email	Score	Date
1087	Maya Rodriguez	[e-mail]	89	2024-02-14
1087	Maya Rodriguez	[e-mail]	89	2024-02-14
2144	James Lin	[e-mail]	92	2024-02-15
2144	James Lin	[e-mail]	92	2024-02-15
3059	Sarah Chen	[e-mail]	77	2024-02-16
3059	Sarah Chen	[e-mail]	77	2024-02-16

Select A1:E12 → Alt + A → M → D → check all columns → OK. It’ll drop exactly 3 rows. Safe here—because no ambiguity.

When to Use UNIQUE + FILTER

Use UNIQUE + FILTER when your definition of “duplicate” is nuanced. Example: you want one contact per email—even if names differ slightly ("J. Smith" vs "John Smith") or statuses vary ("Active" vs "Pending").

Here’s how: In cell G1, paste this formula:

=UNIQUE(FILTER(A2:E12,(B2:B12<>