1. To the right of your data, copy the heading from the column where you want to find unique values. 2. Select a cell in your data set. 3. In Excel 2007, choose the Advanced icon from the Sort & Filter group of the Data ribbon. 4. Choose Copy to another Location 5. In the Copy To box, specify the copy of your heading. In the Figure, this is cell D1 6. Click the box for Unique Records Only 7. Click OK"