Try the Large() function
=large($P$4:$P$65536,1)
is the same as max()
=large($P$4:$P$65536,2)
is the second largest
Small() has a similar comparison to min()
"Jim" wrote:
Returning Descending Values
I currently use the following to find the max number is a column:
=MAX($P$4:$P$65536). If I wanted to find the second highest, then the third
highest, etc.. how would this be written?
Thanks for the help
|