40. Excel Tips - Remove Dupes With Multiple Columns

Nick's picture

This is a follow-on from yesterday's tip and relates to XL 2003

Suppose you have the following data and you want to remove the dupes

(i.e. where both columns are the same):

Remove Duplicates Sorted List

Add a another column containing the concatenation of the previous 2

columns like so:

Remove Duplicates Sorted List

Copy it down, and proceed as with yesterday's tip



Training Video on how to remove Dupes with Multiple Columns: