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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTING THE SAME VALUES IN A SHEET 3
split range address into individual cell addresses 9
Conditional Formatting Formula 3
Baffeling IF statement 7
problem with time subtraction 7
Help needed regarding calculating time 0
Combining two formulas 0
SUMIF "value if false" not working 2

Top