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.


--
pinehead
------------------------------------------------------------------------
pinehead's Profile: http://www.excelforum.com/member.php...o&userid=31721
View this thread: http://www.excelforum.com/showthread...hreadid=514291