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

Pinehead

try:

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

Regards

Trevor


"pinehead" wrote in
message ...

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 exampl
withonly certain formulas in use.
My goal is to only use max,min,count,countif,sum,sumif,if,average o
vlookup
Any further ideas?

Thank you
Anthon

--
pinehea
-----------------------------------------------------------------------
pinehead's Profile: http://www.excelforum.com/member.php...fo&userid=3172
View this thread: http://www.excelforum.com/showthread.php?threadid=51429

<<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" wrote in
message ...

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