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

P

pilzner

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
 
C

Cutter

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.
 
Top