ƒx

Excel UNIQUE Formula

data Difficulty:

One-Click Copy

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

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Returns a list of unique values in a list or range.

Remove duplicates and get a clean list of unique items.

Extract Unique Values

Remove duplicates and get a clean list of unique items.

Inputs

array Range or array to filter.
by_col FALSE for rows (default), TRUE for columns.
exactly_once TRUE to return only items that appear once.

Practical Example

=UNIQUE(A1:A100)

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.