Array formula reference
 

The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h:99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?

You're message is confusing. Post your formula and the re-
state the table range (A1:A99 or A1:H99).

HTH
Jason
Atlanta, GA

-----Original Message-----
The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h:99, say A43. How can I find
the corresponding value in column D, i.e. in this case
D43?
.

Assuming the maximum value occurs only once, regardless of the condition you
are testing in your IF formula,

=VLOOKUP(<your Maxif formula,$A$1:$D$99,4,0)


On Mon, 21 Feb 2005 15:43:16 -0800, "JAK"
wrote:

The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h:99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?

=INDEX(Data!$H$1:$H$1000,MATCH(MAX((TEXT(Data!A$1: A$1000,"dd
mmm")=TEXT(A8,"dd mmm"))*(Data!$B$1:$B1000)),((TEXT(Data!A$1:A$1000, "dd
mmm")=TEXT(A8,"dd mmm"))*(Data!$B$1:$B1000)),0),1)

Your formula, as posted/written returns the maximum value in Column B for
those rows matching the date. You would change the $B$1:$B$1000 to
$D$1:$D$1000 if you want to find the row based on the maximum value in
column D.

The value returned is from column H.

--
Regards,
Tom Ogilvy

"JAK" wrote in message
...
The array formula MAXIF correctly gives me the maximum
value of A in my table A1:h:99, say A43. How can I find
the corresponding value in column D, i.e. in this case D43?