Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|