Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Michigan, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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
  •