Hello--

I have a min value that I pulled from a row that contains several columns. I
am trying to identify what the column label for that min. value is:

So in the example below, I'm pulling the min value of 1 and would like to be
able to return D since that corresponds to the MIN value.

Thanks!!!

A B C D E F
16 3 7 2 29 18

The best approach depends on where and how you wish to use the results.

You say the "min value of 1" ... since the min value in your example is "2",
I assume it's a typo, or you really mean the Small() value of 1.

Anyway - one way:

=ADDRESS(1,MATCH(MIN(A1:F1),A1:F1,0),4)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"CeciliaPDX" wrote in message
...
Hello--

I have a min value that I pulled from a row that contains several columns.
I
am trying to identify what the column label for that min. value is:

So in the example below, I'm pulling the min value of 1 and would like to
be
able to return D since that corresponds to the MIN value.

Thanks!!!

A B C D E F
16 3 7 2 29 18

Hi,

You can use =INDEX(B1:G2,1,match(min(B2:G2),B2:G2,0)). Please note that if
there are multiple minimum values, then this will work only for the first
minimum value.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CeciliaPDX" wrote in message
...
Hello--

I have a min value that I pulled from a row that contains several columns.
I
am trying to identify what the column label for that min. value is:

So in the example below, I'm pulling the min value of 1 and would like to
be
able to return D since that corresponds to the MIN value.

Thanks!!!

A B C D E F
16 3 7 2 29 18