# Excel 2010 Return Day of the Month with Highest Temperature

I have a workbook with sheets for each month on the year.  I want to return the day of the
month with the highest temperature.

The days of the month: 1, 2, 3, ... are located in column A

The highest temperatures for each day are located in column E

I want to insert into a cell the day of the month with the highest temperature for the month.

How do I do that?

Thanks,

Jeremy
Saqib Husain

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jeremy-M

Your solution was fine except you should have used column E not F.

=INDEX(A6:A36,MATCH(MIN(E6:E36),E6:E36,0)),")")

I've requested that this question be closed as follows:

Accepted answer: 0 points for Jeremy-M's comment #a38591422

for the following reason:

In was in error the previous reply should be accepted as the solution, &nbsp;I thought I was accepting the previous reply.<br /><br />Sorry,<br /><br />Jeremy
If you go by the guidelines

https://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26

a B grade may be given if the solution requires you to do "a good amount of extra work" to solve your problem.

Do you really think that changing the column reference from F to E required that much effort?