How can I display only the unique values in one column in Excel?
Select the data, make sure for a column that you have the first cell as a Label, Use an Advanced Filter and choose Unique Values only. You don't need to enter any criteria, just hit ok after checking the Unique Value box.