problematic formula

  • Thread starter Thread starter scottwilson
  • Start date Start date
S

scottwilson

I would be very grateful if someone could assist with this query:

I have a spreadsheet of data, row 1 has the column headers and each ro
underneath has a range of variables.

I am using the MAX formula to obtain the highest value in a number o
the columns (for example: the highest value in columns C to K).

Is there a way of getting this formula to tell me the header ro
associated with the value.

For example: If column K has the highest value and the header for tha
row is "Population" can i get a formula to tell me firsty that th
highest population is X and in the next column that the populatio
refers to whatever the country is ?!

Difficult one I know.

Many thanks for any help.

Scott
 
Let's say your formula is:

=MAX(C2:K2)

To get the column header associated with the maximum thus found, you would
use:

=INDEX($C$1:$K$1,,MATCH(MAX($C2:$K2),$C2:$K2,0))

I'm a bit confused about where the countries are designated, if one of the
headers is "Population".
 
Back
Top