On 6/9/2018 7:22 AM, tdi93 wrote:
Good day, Banters,

I am not new to excel, however I am trying to divide a number of
consignments randomly to a number of clients, but it now seems
impossible to me.
Let me exemplify:

I am not allowed to use the real company data for a project, so:
I have a number of consignments - 30000
which i am trying to divide UNEVENLY to a number of clients - 120

....


For what working definition of "UNEVENLY"?

One each to 119 and 30000-119 to one is about as uneven as gets in one
sense but I suspect that isn't what you're looking for presuming that
everybody does get at least one.

Or another way to ask the question -- what criterion would you use to
disallow a solution?

Just out of curiosity that has nothing really to do with the answer to
the question, just why is an even solution unacceptable?

--