Hi,

Am Thu, 8 Nov 2012 19:47:35 +0000 schrieb Troo:

I have a list of data, the top row being months and the bottom row being
average temperatures. I need a function that will find the highest
average temperature, and then return the month at the top of the list.

do you know, which row is the bottom row? If not, try:
=INDEX(1:1,MATCH(MAX(OFFSET($A$1,COUNTA(A:A)-1,,1,12)),OFFSET($A$1,COUNTA(A:A)-1,,1,12),0))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2