Unique values

1. Select a range of cells and on the Data tab, choose   Advanced in the Sort & Filter group.

2. Choose:
   • Filter the list, in-place
   • Copy to another location

3. Check Unique records only and then select OK.

For more info, see Filter for unique values or remove duplicate values.

1. Select a range of cells and on the Data tab, choose   Advanced.

2. Choose:
   • Filter the list, in-place
   • Copy to another location

3. Check Unique records only and then select OK.

For more info, see Filter for unique values or remove duplicate values.

Finding unique values isn't currently possible in Excel for the web. You can, however, find unique values in the Excel desktop app. 

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.

Note: To remove duplicates in Excel for the web, see Remove duplicates in a column.