assay
operator

f9e231

Subject
UNIQUE
Category
value
Formula
=UNIQUE(A1:A4)
Canonical
{apple; banana; cherry}

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match {apple; banana; cherry}
excel match {apple; banana; cherry}
lattice match {apple; banana; cherry}
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge #NAME?
formulas match {apple; banana; cherry}
pycel diverge #NAME?