I need to make a comparison list in excel
the data should be like this:
a,b,c and e is the suppliers and the numbers are their quotes (Amount)
a b c e
2 3 1 4
3 1 4 2
4 2 3 1
I wand to pick the nameof the supplier quoted low.
The result should be
a b c e Result
2 3 1 4 c
3 1 4 2 b
4 2 3 1 e
Thanks in advance if some one can help me.
