Reference to a column label

[Guest]

I have succesfully created a MAXA formula which retrieves the highest value
in a column of numbers. I would also like to have the label for that highest
number to appear as well. Can this be done?

Example:
Apples 4
Pears 6 MAXA returns the value 8 but I want the column heading
as well.
Oranges 8
Plums 3

 

[Peo Sjoblom]

=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0))

where A2:A6 contain the headers

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[patrickcairns]

Perhaps something like this is the adjacent column

=LOOKUP(MAXA(B1:B10),B1:B10,A1:A10)

 

[Guest]

Hi,

assuming your data starts from A1,

=INDIRECT(ADDRESS(MATCH(MAXA(B1:B4),B1:B4,0),COLUMN()-1))

else if it starts from row n

=INDIRECT(n+ADDRESS(MATCH(MAXA(B1:B4),B1:B4,0),COLUMN()-1))