How to get Excel to show the date aligned to a max value in a column.

**akj1944** · 10-15-2012, 06:27 PM

I have 2 columns of data one has the days of the month and the second is daily rainfall. At month end I have Excel select the max rainfall from column 2. How do I get Excel to select the date that goes with the max rainfall amount?
Any help appreciated
KJ

**Jakobshavn** · 10-15-2012, 06:35 PM

Something like:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

**akj1944** · 10-17-2012, 03:44 AM

Thanks for your help.
Job done.
KJ

**TMS** · 10-15-2012, 06:36 PM

=INDEX(date-range, MATCH(max-rain, rain-range,0))

Regards, TMS

**akj1944** · 10-17-2012, 03:43 AM

Thanks for your help. Job done
KJ

**TMS** · 10-17-2012, 03:50 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save