Step-by-step lesson · Excel
How to use the UNIQUE function in Excel
- Click an empty cell with space below
- Type =UNIQUE(A2:A100)
- Press Return
- Each value appears once in the cells below
More in Excel
- How to format cells as currency, percent and dates in Excel
- How to use SUM, AVERAGE and COUNT in Excel
- How to use SUMIFS and COUNTIFS in Excel
- How to fix numbers stored as text in Excel
- How to fix dates showing as numbers in Excel