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

1. ## 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

2. ## 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
>
>

3. ## 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!!

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

#### 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