Formula Library

UNIQUE

statistical

Returns a list of unique values from a range, removing duplicates. (Dynamic array function)

Syntax

=UNIQUE(array, [by_col], [exactly_once])

Example

Excel
=UNIQUE(A2:A100)

Returns a spilled list of unique values from A2:A100, automatically expanding to fit the results.

Tips & Notes

  • →Available in Excel 365/2021+ and Google Sheets
  • →Results spill into adjacent cells automatically
  • →Combine with SORT for a sorted unique list

See Also

COUNTIF

Need a custom UNIQUE formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.