Nov 25 2021 06:10 AM
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
Dec 11 2021 09:08 AM
HIi@KuroDesu
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
Dec 13 2021 08:29 AM
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
Dec 13 2021 08:51 AM
Hello @KuroDesu
I do not find the new example file. Please attach it, as it would help in understanding the requirement.
Thanks
Tauqeer
Dec 14 2021 12:26 AM
Dec 14 2021 02:16 AM
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