How to create a unique list in Excel 2007.

Instructions:

  1. Select a column you want to delete duplicate records

  2. Click tab "Data"
  3. Click "Remove duplicates"

  4. Click ok!

  5. Click ok!