Is there a function equivalent to the LARGE()

fdmsaraiva
Participant V

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 Solved
0 2 462
1 ACCEPTED SOLUTION

RezaRaoofi
Participant V

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)

View solution in original post

2 REPLIES 2

RezaRaoofi
Participant V

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)

fdmsaraiva
Participant V

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

Top Labels in this Space