Value lookup and replace value with a name

[Walsh1234]

Hello, can someone please help me?:

The below extract shows part of a table that I'm working on.

A B C D E F Minimum SMNBER
0.00 -83.33 -75.00 -83.33 -97.56 -66.67 -97.56
-91.11 -20.00 -95.29 -50.00 -95.12 0.00 -95.29
0.00 -50.00 -50.00 -71.43 0.00 -75.00 -75.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

In the column SMNBER, i need to determine a formula that will detect the minimum value within the range A-F. I then need to convert the decided reference into the corresponding column title. E.g. value -97.56 will appear as E.

If anyone could help with this, I would really appreciate your help as I need to use the formula on quite a big data set.

Thanks for your help!

[sweep]

Hi,

If your data starts at cell A1,

=INDEX($A$1:$F$1,1,MATCH(MIN(A2:F2),A2:F2,0))

in H2 and copied down will give the required result

[Walsh1234]

Thanks Dave, that works perfectly. The only problem I have now though is that on some occasions my minimum value has more than one result.

Could you please suggest to me if it is possible to counteract this, or do you think it best that i just have a separate column with a count formula which i could conditional format to highlight the error?

Thanks again for your help, I had been trying to find a formula all morning!!

Andrew

[Walsh1234]

To clarify, if two minimum values are the same, I only get the name of the first in the row.

Thanks again

[sweep]

I would approach it via conditional format with the countif fuction.

Dave