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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Drop-down calendar for sheet 0
MS Project. Real progress of the project, % complete 1
How can i find the max value within a time range ased on two cells 6
Outlook calendar list 0
Need Help with a VBA subroutine 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Using project as a resource tracker 0

Top