Thread: displaying adjacent cell when using max/min formulae
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default displaying adjacent cell when using max/min formulae
=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

--


Regards,


Peo Sjoblom

"formula428" wrote in message
...
I'm using the max/min formulas to display the appropriate values [say in
column A]. say the maximum is located in cell A20, i'd also like to have
excel display the output of cell B20 in another cell.

how do i do this in Excel 2003?


Reply With QuoteReply With Quote