Associate a calendar date with a maximum value?

  • Thread starter Thread starter Richard
  • Start date Start date
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
 
Richard,

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

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