40. Excel Tips - Remove Dupes With Multiple Columns
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:
»
- Nick's blog
- Login or register to post comments
- 6335 reads
Recent comments
5 years 6 weeks ago
5 years 44 weeks ago
6 years 4 weeks ago
6 years 7 weeks ago
6 years 8 weeks ago
6 years 13 weeks ago
6 years 21 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago
6 years 22 weeks ago