Thread
:
Returning Descending Values
View Single Post
#
6
Bruno Campanini
Posts: n/a
"Domenic" wrote in message
...
For the second highest...
=LARGE($P$4:$P$65536,2)
For the third highest...
=LARGE($P$4:$P$65536,3)
...and so on.
Just for joking:
LARGE(Range, k) = SMALL(Range, n-k+1)
SMALL(Range, k) = LARGE(Range, n-k+1)
Bruno
Reply With Quote