sorting data equally-

P

Pernella

Help---I have 100 rows with 3 columns, 1 column gives the county-2nd column
gives the # of cases and the third column gives the dollar amount for those
cases. I need to distribute the 100 counties among six individuals. The end
result should be that each individual will have the same amount of cases and
the same amount of money. can someone help? Ex:

County Cases Money

01 135 92,255.00
02 735 752,965.65
03 278 12,789.65
04 85 85,254.95
05 12 3,555.14

Thanks!
 
P

Pernella

To clarify, in the example I would have 100 rows with a different amount of
cases and a different amount of money, I would need to divide those 100 rows
so that six people would be assigned the same number of cases generating the
same amount of money. I hope this clarifies the question better. Thanks!
 
Top