| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing up Records between team members
I have 10,000 records that need to be evenly divided between 40 people. The
quantity of records and # of people change weekly. Presently I am manually dividing the # of records by the # of people to determine # of records each, and then copy/pasting each name down 250 or so rows. I have searched throughout the help section to see if there's a formula I could write that would do this (these) task(s) for me, but I'm not having any luck. I was hoping that someone might have a suggestion as the manual process is becoming very tedious. Any help would be GREATLY appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine which team has to look at error again. | Excel Discussion (Misc queries) | |||
| Counting number of forwarding and sending back | Excel Discussion (Misc queries) | |||
| Multiple team "All-Play" Won, loss, tie records | Excel Worksheet Functions | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
Threaded Mode
