View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
formula428 formula428 is offline
external usenet poster
 
Posts: 4
Default displaying adjacent cell when using max/min formulae

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?