Minimum of two cells

[HannahS]

Hi!

I have following small Problem.
Let's say I have to columns, A and B, in each random numbers in the range from 1 to 10.
Now I want to compare those to columns by the Minimum value, such that I have a third column C containg the Minimum value of a row. See the example:

A B C
5 9 5
7 3 3
1 10 1
...
and so on.

Is there a way that I can get another column D which states whether the Minimum value in column C stems from A or B?

A B C D
5 9 5 A
7 3 3 B
1 10 1 A

I can't do it by hand since the original dateset contains several hundred numbers.


Thank you!

[Fotis1991]

Please Login or Register  to view this content.

[HannahS]

Tank you, Fotis1991!