SMALL() formula (opposite of LARGE() formula)

Ragic supports LARGE() but not SMALL(). Excel supports both. Any chance we can get this formula in ragic?

Just for clarity, SMALL() sorts the subtable from smallest to largest and then gets the nth row value. This is the opposite of LARGE() which sorts by largest.


You may combine LARGE() with COUNT() to achieve the same result.

For example,


That’s cool. Didn’t think of that. I created a helper column that changes all the numbers to negative (-A5), but this is better. Would still be nice to just have a SMALL() formula, like excel.