=INDEX(D1:D99,MIN(IF(A1:H99=MAX(A1:H99),ROW(A1:H99 ))))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
JAK wrote:
The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?
--
Dave Peterson
|