Urgent simple formula help

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

try:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Regards

Trevor


"pinehead" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thank you for your response, however i'm attempting to do this example withonly certain formulas in use.
My goal is to only use max,min,count,countif,sum,sumif,if,average or vlookup
Any further ideas?

Thank you
Anthony

<<Any further ideas?>>

No. Your choice. To use VLOOKUP you will need to swap columns A and B to
facilitate the LOOKUP. Alternatively, you could replicate column A after
column B. You could do that with a formula; in cell C1 put the formula =A1
and drag down.

Not sure what you are trying to achieve ... intellectual exercise ?

Other than that, no, no ideas. The solution offered works.

Regards

Trevor


"pinehead" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you for your response, however i'm attempting to do this example
> withonly certain formulas in use.
> My goal is to only use max,min,count,countif,sum,sumif,if,average or
> vlookup
> Any further ideas?
>
> Thank you
> Anthony
>
>
> --
> pinehead
> ------------------------------------------------------------------------
> pinehead's Profile:
> http://www.excelforum.com/member.php...o&userid=31721
> View this thread: http://www.excelforum.com/showthread...hreadid=514291
>