Forum Discussion

KuroDesu's avatar
KuroDesu
Copper Contributor
Nov 25, 2021

Dispatch a list randomly with equal amounts

Hello all,
I'd like some help I need to dispatch a list of values randomly between another list:
EG. List of 10 values (list 1) to be randomly assigned to 3 users (list 2)
But when I use the =choose(Randbetween etc... the values don't come out equally assigned
Discrepancy between users -  user 1 gets 5 and user 2 gets 2 etc
How can I make it dispatch all values based on an average -> List 1 devised by List 2
Much appreciate it 🙂 Thank you 

excel
Formulas and Functions

5 Replies

  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Dec 11, 2021

    HIiKuroDesu 

     

    As per my understanding, the below formula may help you to randomly assign values from a list to the users:

     

    =INDEX($C$5:$C$14,RANDBETWEEN(1,COUNT($C$5:$C$14)),1)

     

    Please refer to the attached file and let me know if your requirements are different from this.

     

     

    Thanks

    Tauqeer

    • KuroDesu's avatar
      KuroDesu
      Copper Contributor
      Dec 13, 2021

      tauqeeracma 

      Hello

      Thank you for your answer I'm afraid I wasn't very clear in my request:

      I need the assignment to take in consideration the the "fair amount"

      So to simplify:

      10 Fruits

      5 Agents

      10/5= 2

      I need to have a distribution of 2 fruits randomly per agent
      I've attached a new eg. file

      Thank you

      • tauqeeracma's avatar
        tauqeeracma
        Iron Contributor
        Dec 13, 2021

        Hello KuroDesu 

         

        I do not find the new example file. Please attach it, as it would help in understanding the requirement.

         

        Thanks

        Tauqeer

Resources