Hi Experts,
need your help if you could solve my problem
the problem is I need to allocate stock from lowest rank store to top rank store.
sample file as attached, the result I need is highlighted in Green.
Thanks
Hi Experts,
need your help if you could solve my problem
the problem is I need to allocate stock from lowest rank store to top rank store.
sample file as attached, the result I need is highlighted in Green.
Thanks
You have a simple SUM() function in the green cells - did you upload the correct file?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford,
yes it is the correct file, I put the formula sum() to emphasize if the result is the sum of row 3 dan row 4
So then how does that show what ranking yo want to display?
Hi Ford,
Ok, to clarify, what I need is to do allocation from the store which has excessive stock to other stores which need it
how? I set the allocation priority rule for which stores need to be allocated first, using the rank from P3:T3.
the lowest store with excessive stock need to give their stock to the top stores (based on rank) --> AC3: AG3
actually the real problem is at AC3:AG3
Last edited by halimgunawan; 09-29-2020 at 12:49 AM.
anyone can help pls?
Is anyone here able to solve this issue? really need your help. Thx in advance
Last edited by halimgunawan; 09-29-2020 at 10:26 PM.
Is anyone here able to solve this issue? really need your help. Thx in advance
Visited several times and quit several times also. It is too complicated. I will ask somebody jump in to see if they can help you.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks