Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get the Ans
Hi,
Supplier A B C D Min Cost Column for 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 to advice on the formula to get the ans on the "Column for Ans" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get the Ans
Assuming that column E has the minimum, then in F1 enterr:
="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D") and copy down -- Gary''s Student - gsnu200850 "Sky" wrote: Hi, Supplier A B C D Min Cost Column for 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 to advice on the formula to get the ans on the "Column for Ans" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get the Ans
Hi
="Supplier "&INDEX($A$1:$D$1,MATCH(E2,A2:D2,0)) -- Regards Roger Govier "Sky" wrote in message ... Hi, Supplier A B C D Min Cost Column for 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 to advice on the formula to get the ans on the "Column for Ans" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get the Ans
Thanks Gary,
Can only get 1 to 3 but 4 and 5 under Supplier C and cannot get "Gary''s Student" wrote: Assuming that column E has the minimum, then in F1 enterr: ="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D") and copy down -- Gary''s Student - gsnu200850 "Sky" wrote: Hi, Supplier A B C D Min Cost Column for 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 to advice on the formula to get the ans on the "Column for Ans" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to get the Ans
Here is the correction:
="Supplier " & CHOOSE(MATCH(E1,A1:D1,0),"A","B","C","D") -- Gary''s Student - gsnu200850 "Sky" wrote: Thanks Gary, Can only get 1 to 3 but 4 and 5 under Supplier C and cannot get "Gary''s Student" wrote: Assuming that column E has the minimum, then in F1 enterr: ="Supplier " & CHOOSE(MATCH(E1,A1:D1),"A","B","C","D") and copy down -- Gary''s Student - gsnu200850 "Sky" wrote: Hi, Supplier A B C D Min Cost Column for 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 to advice on the formula to get the ans on the "Column for Ans" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|