Lookup Max Date
Posted by Riki Phelan on August 21, 2001 10:55 PM
I have a list of daily data for a year in cols A, B, and C as:
-Month- -Date- -Temp-
Using AutoFilter, I display a particular month.
I extract the max temp with =SubTotal(4,C4:C369)
How am I able to extract the date that max temp occured from my filtered list?
This works: =SUBTOTAL(1,INDEX(B4:B369,MATCH(C375,C4:C369,0),1)) but only if the temp is unique in the year. It returns an error if I display all of July. This is becuase I have 30.0 on Jan 10, and 30.0 on Jul 10.
Anyone know how I can get the date of the max temp returned from a filtered list? I'm at a loss...