View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jhg1226
 
Posts: n/a
Default Reference to a column label

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