There are two main ways to filter for unique values in Excel:

Method 1: Using the Advanced Filter

1. Select the data range you want to filter.
2. Go to the "Data" tab on the ribbon.
3. In the "Data Tools" group, click "Advanced."
4. In the "Advanced Filter" window, choose "Copy to another location" under the "Action" section.
5. Click the button next to "Copy to" and choose the cell where you want the list of unique values to begin.
6. Important: Check the box labeled "Unique records only."
7. Click "OK."

Excel will copy only the unique values from your data range to the specified location.

Method 2: Using the UNIQUE Function (Excel 365 only)

1. Select a blank cell where you want the list of unique values to appear.
2. Enter the formula `=UNIQUE(A1:A10)` (replace A1:A10 with your actual data range).
3. Press Enter.

The UNIQUE function will return a list of all the unique values from your data range in the selected cell.

Additional Notes:

* Both methods will display the unique values only, excluding duplicates.
* When using the Advanced Filter, the copied unique values will include the header row from your data range if it exists.
* The UNIQUE function is only available in Excel 365. If you are using an older version of Excel, you can still use the Advanced Filter method.