• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Random allocation

Hi Team,

From the attached file I need to allocate the task managers randomly. For Example John is a task manager he should get 13 allocations equally from all the 4 locations and divided among all the employees. Similarly all the 4 task managers get random allocation for all the 4 locations and random samples matching all the employees.
At the end A1 emaployes 4 randon samples should be allocated between task managers in random basis.

Kindly help on this please.
 

Attachments

  • Logic.xlsx
    25.8 KB · Views: 10
Back
Top