Link to home
Start Free TrialLog in
Avatar of Jeremy-M
Jeremy-M

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

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

ASKER

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?
No,  how do I change your grade?
You can click on the "Request attention" button (below the lower right corner of the question box) and send a request to the mods. They may either reopen the question for grading or change the grade as per your request.
Thanks both.