formula to find second (third, etc.) largest number in a list

M

MSJ

Operating System: Mac OS X 10.6 (Snow Leopard) What is the formula to find the second largest number in a list? MAX worked fine to find the largest number, need help to find next to the largest number. I'm sure this is easy (but not for me).
 
C

Carl Witthoft

Operating System: Mac OS X 10.6 (Snow Leopard)

What is the formula to find the second largest number in a list? MAX worked
fine to find the largest number, need help to find next to the largest
number. I'm sure this is easy (but not for me).
Click to expand...

LARGE()
 
Top