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
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