Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get
Hi,
Supplier A B C D Min Cost Ans 1 $1.00 $2.00 $3.00 $4.00 $1.00 Supplier A 2 $2.00 $1.00 $3.00 $4.00 $1.00 Supplier B 3 $5.00 $6.00 $7.00 $8.00 $5.00 Supplier A 4 $8.00 $7.00 $5.00 $6.00 $5.00 Supplier C 5 $7.00 $6.00 $5.00 $4.00 $4.00 Supplier D Could anyone help and advice me is there any fomula to get on the column indicate Ans. The Ans is indicate as per below Supplier A Supplier B Supplier A Supplier C Supplier D |