How do I get MAX, MAX -1, MAX -2
 

I have a list of numbers that I need the MAX number for......so far
that's easy, but I also need MAX -1 and MAX -2.

In other words I need the 3 greatest numbers in the list.

I DO NOT want to sort.

I need this as a formula.

Thanks in advance for your help

-P


--
pilzner
------------------------------------------------------------------------
pilzner's Profile: http://www.excelforum.com/member.php...o&userid=25976
View this thread: http://www.excelforum.com/showthread...hreadid=393410

Check out the LARGE() function.

LARGE(A1:Z1,1) gives the largest number in the range
LARGE(A1:Z1,2) gives the second largest
etc.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=393410

Great Thanks


--
pilzner
------------------------------------------------------------------------
pilzner's Profile: http://www.excelforum.com/member.php...o&userid=25976
View this thread: http://www.excelforum.com/showthread...hreadid=393410