Remove duplicates in Excel

1. make a selection
2. go to the "DATA" tab
3. click the "Advanced" button by the "Filter" button
4. in the "Advanced Filter" dialog box check the "Unique records only" checkbox
5. copy your list elsewhere with the power of the "Advanced Filter" dialog box