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):

Add a another column containing the concatenation of the previous 2


columns like so:

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

Training Video on how to remove Dupes with Multiple Columns: