View Single Post
  #6   Report Post  
Bruno Campanini
 
Posts: n/a
Default

"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