How To Get Distinct Values In Excel?

Select the range of cells

Go to the Data tab

Click Advanced in the Sort & Filter group

Choose Copy to another location

Check Unique records only

Select the Copy to box

Click OK

Use the Remove Duplicates feature on the Data tab

Use the UNIQUE function in Excel 365 or Excel 2021

Use a PivotTable and place the field in Rows

Use Filter and select unique items manually

Suggested for You

Trending Today