How to Use the UNIQUE Function in Excel

UNIQUE returns distinct values or distinct rows from a range. Use it when you want a live de-duplicated list without manually removing duplicates from the source data.

That makes it useful for owner lists, category lists, project tags, client names, and any workflow where one messy table needs a cleaner derived view.

The syntax

• array — the range Excel should inspect
• [by_col] — optional; use TRUE to compare columns instead of rows
• [exactly_once] — optional; use TRUE to return only values that appear once

Most of the time, you only need the first argument.

Basic example

If column B contains task owners and you want a distinct owner list:

Excel spills a clean list of each owner once.

That is a fast way to build review dropdowns or summary sections from a project tracker template.

Return unique rows instead of one column

If columns A:C contain task name, owner, and status:

Excel returns distinct rows across the full three-column range.

That is useful when you want to collapse repeated records into one live result set without changing the source table.

Return values that appear exactly once

If you only want values that occur one time:

That excludes repeated values and returns only entries that appear exactly once.

This is helpful when you need to identify one-off owners, categories, or tags instead of a general distinct list.

UNIQUE vs Remove Duplicates

If you need a live derived list, use UNIQUE.

If you want to permanently clean the source data one time, the Remove Duplicates tool may be better.

Common UNIQUE mistakes

Where UNIQUE fits best

UNIQUE is most useful when the workbook needs lightweight derived views such as:

• a distinct list of project owners
• a clean set of objective names in an OKR tracker
• a de-duplicated employee list in a schedule template

It is one of the easiest ways to make a messy operating sheet more reusable.

The Griddy way

UNIQUE is easy once you know the syntax, but people still waste time deciding which range to use, why the spill is blocked, or whether they should be de-duplicating rows or just one column.

"Pull a distinct list of project owners from this tracker, sort it alphabetically, and ignore any blank rows"

Griddy can build the formula chain and place the result into the summary view that needs it.