+ Reply to Thread
Results 1 to 9 of 9

Allocation from lowest rank to top rank

  1. #1
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Allocation from lowest rank to top rank

    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
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,082

    Re: Allocation from lowest rank to top rank

    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

  3. #3
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Re: Allocation from lowest rank to top rank

    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

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,082

    Re: Allocation from lowest rank to top rank

    So then how does that show what ranking yo want to display?

  5. #5
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Re: Allocation from lowest rank to top rank

    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.

  6. #6
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Re: Allocation from lowest rank to top rank

    anyone can help pls?

  7. #7
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Re: Allocation from lowest rank to top rank

    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.

  8. #8
    Registered User
    Join Date
    06-24-2020
    Location
    Jakarta
    MS-Off Ver
    2013
    Posts
    41

    Re: Allocation from lowest rank to top rank

    Is anyone here able to solve this issue? really need your help. Thx in advance

  9. #9
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,477

    Re: Allocation from lowest rank to top rank

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rank lowest to highest using 2 columns
    By audax48 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-05-2020, 11:56 PM
  2. [SOLVED] [Help] Rank From Lowest to highest
    By gentle.diether in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2015, 08:21 AM
  3. Rank from highest to lowest
    By mastertonn in forum Excel General
    Replies: 7
    Last Post: 07-31-2014, 12:57 PM
  4. Replies: 2
    Last Post: 10-30-2013, 09:50 PM
  5. [Rank] Points Allocation
    By lavenlaar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2013, 02:29 AM
  6. Allocation based on Rank
    By ValGlad in forum Excel General
    Replies: 5
    Last Post: 03-02-2011, 07:47 PM
  7. Rank where lowest value is highest rank
    By mile3024 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2005, 07:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts