UNIQUE Formula Generator
UNIQUE returns a list of distinct values from a range, removing duplicates. It's a dynamic array function — the results spill into adjacent cells automatically.
Syntax
=UNIQUE(range, [by_col], [exactly_once])Try it — generate a UNIQUE formula
Examples
List of unique departments
=UNIQUE(B2:B100)Returns each department name only once from column B.
Unique combinations
=UNIQUE(A2:B100)Returns unique pairs of values from columns A and B combined.
Tips
- ✓UNIQUE is a dynamic array formula — make sure the cells below are empty for results to spill.
- ✓Combine with SORT to get a sorted unique list: =SORT(UNIQUE(A:A)).
- ✓Set exactly_once to TRUE to return values that appear only once (no duplicates at all).
Related Formulas
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
COUNTIFS
COUNTIFS counts cells that meet multiple criteria across different columns. Perf...
Text Split / Extract
Split text into parts, extract substrings, or parse structured data like email a...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free