assay
operator

unique-1d-column

Subject
UNIQUE
Category
value
Formula
=UNIQUE(A1:A5)
Canonical
{1; 2; 3}

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match {1; 2; 3}
excel match {1; 2; 3}
lattice match {1; 2; 3}
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge
formulas match {1; 2; 3}
pycel diverge #NAME?