Thread: How to select the best 2 values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How to select the best 2 values
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)

--
Rick (MVP - Excel)


"Mr.Param" wrote in message
...
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

Reply With QuoteReply With Quote