# Thread: Formula for value of column title (2000)

1. ## Formula for value of column title (2000)

If this has already been answered, my apologies but, with the search engine down, I can't find what I'm looking for. Anyway...

I'd like to create a formula that will give me the value of a column or row label that has the highest or lowest value from another column or row.

For example, let's say that I have a table with 51columns, column A with row labels (starting in cell A2) and then one column for each state (in cells B1:AY1), and three rows: population in row 2, average rainfall in row 3 and average age in row 4. In column AZ (the 52nd column), I want a list of those states with the maximum population (in cell AZ2), rainfall (in cell AZ3) and age (in cell AZ4). What would those formulas be?

Thanks.

2. ## Re: Formula for value of column title (2000)

In AZ2 enter:
<pre>=INDEX(\$B\$1:\$AY\$1,MATCH(MAX(B2:AY2),(B2:AY2), 0))</pre>

Copy this to AZ3 and AZ4.
[Note:If there is a tie the first one wins]

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•