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