| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Divide a number in one cell into several others UNEVENLY
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to divide the number in one cell into multiple cells | Excel Worksheet Functions | |||
| Enter number in cell and have it divide by 4 | Excel Discussion (Misc queries) | |||
| Divide number and add remainder in another cell | Excel Discussion (Misc queries) | |||
| How do I divide a number by another number when there is no divis. | New Users to Excel | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Threaded Mode
