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.