How To Remove Duplicates From The List Excel 2007

Select the list; go under Data tab and Data tools section. Choose "Remove duplicates". Now you can choose which columns are searched for duplicates. Press "OK". A message will let you know how many duplicates were found.

officetodo.com/