sorting data equally-
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!
|