I´m stuck in a little problem.
I have a Excel sheet with 40 Names (Column A) and I want to designate every of the 40 Names a random Number between 1-10 in Column B.
The state now is that I get for every name a random number, but for example number 4 is 7 times and number 8 just 2 times assigned to a unique name.
I want to limit the duplications to maximum of 4 that I have in the end 10teams out of 4people randomly generated.
Anyone has an idea how to solve that?
Thanks a lot!