Thread: Reference for MAXIF array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jak Jak is offline
external usenet poster
  
Posts: 8
Default Reference for MAXIF array formula
The array formula MAXIF correctly gives me the maximum
value of A in a separate sheet in my table Sheet2!A1:H99, say A43. How can
I find
the corresponding value in column D in A1:H99, i.e. in this case Sheet2!D43?


Reply With QuoteReply With Quote