Is there a function equivalent to the LARGE()

(Dâmaso Saraiva) #1

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

(Reza Raoofi) #2

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)

(Dâmaso Saraiva) #3

@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!