Software

Don't think there's an easy way to do this without writing some VBA code. This would be pretty simple to do - let me know if you're interested. You could create a new worksheet function that you could use in the Result column just like other built-in worksheet functions (e.g. =Sum() ).

Hope this helps.

Hi there,
Here is a possible solution to your problem.
In cell E7 put a, F7 b, etc. Should look like this when done

a b c e Result
2 3 1 4
3 1 4 2
4 2 3 1

Now in I8 put this formula:

=Offset($D$7,0,Match(Min(E8:H8),E8:H8,0))

Once entered use the AutoFill handle to drag the formula in I8 down as many rows as you need. You will, of course, need to adjust the cell references to meet your requirements.

Luck,
Mike

Sir,
As per your request here is my second posting. I am happy to have been of help.

Mike

This question was closed by the author