assay
spill-edge

sort-of-filter

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

Per-engine results

matches canonical diverges no fixture

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