Thread: Formula to get
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sky[_2_] Sky[_2_] is offline
external usenet poster
 
Posts: 42
Default 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