Associate a calendar date with a maximum value?

R

Richard

Hi,
I have a set of columns with calendar dates in one row
and numbers for those dates in the next row.
I can get the maximum value in the numbers row, but how
do I find the calendar date associated with it?
Thanks,
Richard
 
B

Bob Phillips

Richard,

Assuming the dates are in A1:Z1, values in A2:Z2, try

=INDEX(A1:Z1,1,MATCH(MAX(A2:Z2),A2:Z2,0))
 
Top