I am looking for a way to get the 5 higher values in a series. In a way, I would like to know if there is an equivalent to "max", but that take the 5 higher rather than the highest, or some workaround. Thanks !
Nicolas
I am looking for a way to get the 5 higher values in a series. In a way, I would like to know if there is an equivalent to "max", but that take the 5 higher rather than the highest, or some workaround. Thanks !
Nicolas
Use the LARGE function.
= LARGE(A1:A100,1) -- first largest
= LARGE(A1:A100,2) -- second largest
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks