assay
lambda

filter-basic

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
formulas match {1; 3; 5}
pycel diverge #NAME?