assay
lambda

7deee0

Subject
FILTER
Category
value
Formula
=FILTER({1;2;3;4;5}, {1;0;1;0;1})
Canonical
{1; 3; 5}

Per-engine results

matches canonical diverges no fixture

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