minimum value column name look up
 

Is it possible to lookup the minimum value in a set of numbers in a row and
then also list the column name for where the minimum answer value came from?

minimum value column name look up
 

In A1:F1 I have the numbers 90, 80, 50, 60, 85, 75
The formula =MATCH(MIN(A1:F1),A1:F1,0) returns the value 3 since the
minimum value resides in the third cell of the array.
This formula returns the value C - the column with the min value:
=INDEX({"A","B","C","D","E","F"},MATCH(MIN(A1:F1), A1:F1,0))
while this returns $C$1
=ADDRESS(1,MATCH(MIN(A1:F1),A1:F1,0))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"shifty" wrote in message
...
Is it possible to lookup the minimum value in a set of numbers in a row
and
then also list the column name for where the minimum answer value came
from?

minimum value column name look up
 

Assuming your set of numbers is in row 2 and your column names are in row 1,
this should return the minimum:
=MIN(2:2)
and this the column heading:
=INDEX(1:1,MATCH(MIN(2:2),2:2,0))

If you want to put the first of these in the same row as your numbers, you
will need to specify the range more precisely, for example:
=MIN(A2:H2)
with the formula in column I or later.

"shifty" wrote in message
...
Is it possible to lookup the minimum value in a set of numbers in a row
and
then also list the column name for where the minimum answer value came
from?