assay
operator

unique-1d-strings

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
formulas match {apple; banana; cherry}
pycel diverge #NAME?