minimum value column name look up

S

shifty

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?
 
B

Bernard Liengme

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
 
S

Stephen

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.
 
Top