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 =choo...
excel
Formulas and Functions
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