Is there a function equivalent to the LARGE() function in excel, which allows returning the smallest, largest or nth largest value in a number list?
If not, I was thinking of this workaround: INDEX(SORT(list),COUNT(list)-intendedPosition)
Better way?
Cheers
Solved! Go to Solution.
Yes, if it is for a list of values, then a combination if INDEX() and SORT() is the closest solution to your goal. Largest: INDEX(SORT(List, true), Position) Smallest: INDEX(SORT(List), Position)
Yes, if it is for a list of values, then a combination if INDEX() and SORT() is the closest solution to your goal. Largest: INDEX(SORT(List, true), Position) Smallest: INDEX(SORT(List), Position)
@RezaRaoofi Ah nice, thatโs a good improvement, if I just reverse the sorting I donโt need to count the list to get the smallest value. Cheers!
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |