+ Reply to Thread
Results 1 to 3 of 3

How do I: Extract column headers based on lowest number in sequence

  1. #1
    WolfJack
    Guest

    How do I: Extract column headers based on lowest number in sequence

    I'd like for Excel to return the colomn "name" based on the lowest value in
    the sequence. For example-
    Columns are A, B, C, D, E, F, G
    Column names are in row 1
    Rows 2-415 will have a series of numbers
    Column H will contain the results for each individual row

    I know I can use =SMALL(A3:G3,1) to get me the lowest value. The problem I
    am having is how do I them translate that into the name of the column.

    Thanks
    -Adam



  2. #2
    Ardus Petus
    Guest

    Re: How do I: Extract column headers based on lowest number in sequence

    =INDEX(A1:G1,1,MATCH(MIN(A3:G3),A3:G3,0))

    HTH
    --
    AP

    "WolfJack" <wolfjack@wolfmoon.org> a crit dans le message de news:
    449997b0$0$12729$cc2e38e6@news.uslec.net...
    > I'd like for Excel to return the colomn "name" based on the lowest value
    > in the sequence. For example-
    > Columns are A, B, C, D, E, F, G
    > Column names are in row 1
    > Rows 2-415 will have a series of numbers
    > Column H will contain the results for each individual row
    >
    > I know I can use =SMALL(A3:G3,1) to get me the lowest value. The problem
    > I am having is how do I them translate that into the name of the column.
    >
    > Thanks
    > -Adam
    >
    >




  3. #3
    adam.lyle@gmail.com
    Guest

    Re: How do I: Extract column headers based on lowest number in sequence


    Ardus Petus wrote:
    > =INDEX(A1:G1,1,MATCH(MIN(A3:G3),A3:G3,0))
    >
    > HTH
    > --
    > AP
    >


    Perfect!

    Thank you very much!!

    -Adam


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1