UNIQUE

UNIQUE function in Excel: Unique values in list or range.

November 5, 2026

Excel functions / Lookup & Reference

Lookup & Reference function · Excel

UNIQUE function

Unique values in list or range.

Platform	Status
Excel	Listed
Google Sheets	Listed

Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.