UNIQUE
Array FormulasLearn UNIQUE to extract distinct values from a range. Create dynamic lists without duplicates that update automatically.
Syntax
UNIQUE(array, [by_col], [exactly_once])Parameters
arrayThe range or array to extract unique values from
by_colFALSE=compare rows (default), TRUE=compare columns
exactly_onceFALSE=distinct values (default), TRUE=values appearing exactly once
Examples
=UNIQUE(A2:A100)Get unique values from column A
=UNIQUE(A2:C100)Get unique rows across multiple columns
=SORT(UNIQUE(A2:A100))Sorted unique values
Common Errors
#CALC! - Empty result
Pro Tips
Results spill automatically
Use exactly_once=TRUE to find values that appear only once
Combine with SORT for alphabetical unique lists
Related Functions
Need Help with UNIQUE?
Describe your specific use case and our AI will generate the perfect UNIQUE formula for you.
Generate UNIQUE Formula