UNIQUE Function in Excel
Learn how to use the UNIQUE function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
UNIQUE(array, [by_col], [exactly_once])arrayRequiredThe range or array to evaluate for unique values.
by_colOptionalOptional TRUE to compare columns instead of rows.
exactly_onceOptionalOptional TRUE to return values that appear only once.
Examples
=UNIQUE(B2:B200)Builds a deduplicated customer list from the source column.
=UNIQUE(D2:D200, FALSE, TRUE)Returns only entries that occur exactly one time in the range.
Common mistakes
Check the argument order, data types, and references used in UNIQUE.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.