Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
Hi All,
My stock of products are in four stores, for each store either I am over stock or I am having a lower stock than the needed qty. I need a formula that can transfer the products from the stores were I am over stock to the stores that needs this stock. Can any one help with this. Example of the isuue, P.ref store 1 store 2 store 3 store 4 over missing over missing over missing over missing p.ex 4 6 9 7 P.yx 10 12 20 5 P.xx 3 5 2 4 Thanks in advanced. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
Looks like a straightforward problem for excel solver. You will need to
ensure that it is included in your addins firroo wrote: Hi All, My stock of products are in four stores, for each store either I am over stock or I am having a lower stock than the needed qty. I need a formula that can transfer the products from the stores were I am over stock to the stores that needs this stock. Can any one help with this. Example of the isuue, P.ref store 1 store 2 store 3 store 4 over missing over missing over missing over missing p.ex 4 6 9 7 P.yx 10 12 20 5 P.xx 3 5 2 4 Thanks in advanced. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200808/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
Thank you for your answer, however I didn't understand it can you please
clarify more. Thanks "edvwvw via OfficeKB.com" wrote: Looks like a straightforward problem for excel solver. You will need to ensure that it is included in your addins firroo wrote: Hi All, My stock of products are in four stores, for each store either I am over stock or I am having a lower stock than the needed qty. I need a formula that can transfer the products from the stores were I am over stock to the stores that needs this stock. Can any one help with this. Example of the isuue, P.ref store 1 store 2 store 3 store 4 over missing over missing over missing over missing p.ex 4 6 9 7 P.yx 10 12 20 5 P.xx 3 5 2 4 Thanks in advanced. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200808/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help
"Herbert Seidenberg" wrote: No Solver needed: http://www.savefile.com/files/1731961 Thank you so much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|