How do I do this in Excel?

P

PC

You could use Data Filter to eliminate the duplicates.

Data/Filter/Advanced and make sure you select the "Unique
Items Only" option.

Though, Access would be a better tool if you have a large
amount of data to sort through.

HTH

PC
 
Top