Dispatch a list randomly with equal amounts

[KuroDesu]

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 

[#2]

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

[#3]

@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

[#4]

Hello @KuroDesu 

I do not find the new example file. Please attach it, as it would help in understanding the requirement.

Thanks

Tauqeer

[#5]

@tauqeeracma 

I'm sorry here it is the file.

[#6]

HI@KuroDesu 

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