assay
external

query-select-col

Subject
QUERY
Category
value
Formula
=QUERY({1,"a";2,"b";3,"c"}, "select Col2")
Canonical
{a; b; c}

Owning divergences (2)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match {a; b; c}
excel diverge #NAME?
lattice match {a; b; c}
ironcalc diverge #NAME?
hyperformula diverge #NAME?
libreoffice diverge
formulas diverge #NAME?
pycel diverge #NAME?