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

All i could achieve at the moment is obtaining either an even spread
throughout the sheet (250), or get a randomization for the first 50
clients or so, afterwards getting a repetitive amount.

Is there any formula/combination that can divide my sum to the clients
without noticing an actual pattern?

Thank you in advance!!

Teddy

Use a helper column and assign a "weight" to clients which you'll use to
determine how many consignments they get. Since the mean is 250 per (3000/120)
you can use the 'Weight" value to set the variance per client. In the end, the
distribution should equal the total number of consignments.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion