Great answer to my questions. Thank you. One more follow up. How do I get
the nth value to change when I am dragging down the cells? The nth is
remaining the same.
"Duke Carey" wrote:
Find the nth largest value by way of
=LARGE($P$4:$P$65536,n)
"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
|