How to select the best 2 values

M

Mr.Param

hi,

I have 3 values, e.g, A1=67, B1=89, C1=92
At cell D1 and E1, how to get the best two highest values appear
automatically. TQ
 
R

Rick Rothstein

You have two choices for D1, only one choice for E1...

D1: =LARGE(A1:C1,1) or MAX(A1:C1)

E1: =LARGE(A1:C1,2)
 
Top