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

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

        HIKuroDesu 

         

        In your requirement, the users' & fruits' list is fixed. You basically want to distribute 2 fruits randomly to each user. If this is the case then please find the attached file that assigns fruits randomly in column_C among the users. Whenever you will update any cell, column C will produce a new list.

         

         

        Please let me know if this serves your purpose or otherwise.

         

        Thanks

        Tauqeer

Resources