Ok, here is what i'm trying to do. I have 2 colums, b and c.
B is a list of days in the month and c is a list of each temp for each day.

I need to write a simple formula that will find the highest temp in c and then list the number in column a that is on the same row. so if the highest temp is 101 degrees and that happend on the 18th i nee dit to find the max which is 101 and then return 18.

I would prefer to keep it simple and only use

count min max countif sum sumif if average hlookup and vlookup if possible.

thank you all.