Comparing values and returning the column heading

Is there a way to take the max value of a range of cells ( say a3:g3 ) and
return the row 1 value of that?

Like if max(a3:g3) would say the value of f3 is the largest, I would like
the cell to actually return the value (company name) of F1


Thanks,
Steven

How about:

=INDEX(A1:G1,MATCH(MAX(A3:G3),A3:G3,0))



Steven Brobst wrote:
>
> Is there a way to take the max value of a range of cells ( say a3:g3 ) and
> return the row 1 value of that?
>
> Like if max(a3:g3) would say the value of f3 is the largest, I would like
> the cell to actually return the value (company name) of F1
>
> Thanks,
> Steven

--

Dave Peterson

One way:

=INDEX(A1:G1,MATCH(MAX(A3:G3),A3:G3,FALSE))

In article <[email protected]>,
"Steven Brobst" <[email protected]> wrote:

> Is there a way to take the max value of a range of cells ( say a3:g3 ) and
> return the row 1 value of that?
>
> Like if max(a3:g3) would say the value of f3 is the largest, I would like
> the cell to actually return the value (company name) of F1
>
>
> Thanks,
> Steven

=INDEX(A:G1,MATCH(MAX(A3:G3),A3:G3,0))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Steven Brobst" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to take the max value of a range of cells ( say a3:g3 ) and
> return the row 1 value of that?
>
> Like if max(a3:g3) would say the value of f3 is the largest, I would like
> the cell to actually return the value (company name) of F1
>
>
> Thanks,
> Steven
>
>
>
>