How to allocate Number to list member based on Rank of list member

Hello Team,


I have list route which has parent city.Every City can have more that 100 route.every Route has capacity of goods can be transfer.i have ranked these route based on some factor.I want to allocate the demand quantity to these route based on lowest to highest rank considering capacity of route and.

pune capacityRankAllocation 





Best Answer

  • Misbah
    Answer ✓



    See if this helps. You may have to use RANKCUMULATE Function/Cumulate Function here




  • Thank You @Misbah , for pointing to correct function.


     I was able to achieve it with RANKCUMULATE function.


    Thank you So much.