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

Feature Request
1

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.

2

Hi,

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

For example,

圖片
圖片1498×586 162 KB

Result,

圖片
圖片648×506 37.7 KB

3

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.