Great answer to my questions. Thank you. One more follow up. How do I get
the number value to change when I am dragging down the cells? The 1 is
remaining the same.
"Chip Pearson" wrote:
Jim,
See the LARGE function. For example, to return the second largest
number, use
=LARGE(P4:P65536,2)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Jim" wrote in message
...
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