UNIQUE

Unsupported (not recognized)

Category: Lookup and reference · Last tested 2026-07-04

Support matrix

Engine	Documented	Live-tested	Verdict
Excel	Yes	Not yet	n/a
Google Sheets	Yes	Not yet	n/a
LibreOffice Calc	No	Yes (24.2.7.2, 2026-07-04)	Unsupported (not recognized)

=UNIQUE(A1:A5) on LibreOffice Calc returned #NAME?, but the documented/expected result is {1, 2, 3}. MISMATCH vs expected: value mismatch: expected 1, got '#NAME?'
=UNIQUE(A1:A5,FALSE,TRUE) on LibreOffice Calc returned #NAME?, but the documented/expected result is {3}. MISMATCH vs expected: value mismatch: expected 3, got '#NAME?'
=UNIQUE(A1:C2,TRUE) on LibreOffice Calc returned #NAME?, but the documented/expected result is {1, 2}. Column A and column C are identical (1,1); unique columns are {1,2} and {1,1} but by_col dedups the repeated column, leaving 2 columns: [1,2] and [1,1] -> flatten to first row [1,2]; MISMATCH vs expected: value mismatch: expected 1, got '#NAME?'
=UNIQUE(A1:A3) on LibreOffice Calc returned #NAME?, but the documented/expected result is {5, 6, 7}. MISMATCH vs expected: value mismatch: expected 5, got '#NAME?'

Formula	Description	Result	Expected	Verdict
=UNIQUE(A1:A5)	Basic unique list preserving first-occurrence order	{#NAME?, #NAME?, #NAME?}	{1, 2, 3}	Mismatch
=UNIQUE(A1:A5,FALSE,TRUE)	exactly_once=TRUE returns only items that appear exactly once	{#NAME?}	{3}	Mismatch
=UNIQUE(A1:C2,TRUE)	by_col=TRUE compares whole columns instead of rows	{#NAME?, #NAME?}	{1, 2} Column A and column C are identical (1,1); unique columns are {1,2} and {1,1} but by_col dedups the repeated column, leaving 2 columns: [1,2] and [1,1] -> flatten to first row [1,2]	Mismatch
=UNIQUE(A1:A3)	Input with no duplicates returns the input unchanged	{#NAME?, #NAME?, #NAME?}	{5, 6, 7}	Mismatch