assay
external

3d3ee3

Subject
SORTN
Category
value
Formula
=SORTN({5;2;8;1;4}, 3, 0, 1, TRUE)
Canonical
#NAME?

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

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