Reference to a column label

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Perhaps something like this is the adjacent column

=LOOKUP(MAXA(B1:B10),B1:B10,A1:A10)
 
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))
 
Back
Top