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!

sorting data equally-
 

before/after examples??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pernella" <Pernella @discussions.microsoft.com wrote in message
...
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!

sorting data equally-
 

before.


"Don Guillett" wrote:

before/after examples??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pernella" <Pernella @discussions.microsoft.com wrote in message
...
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!

sorting data equally-
 

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!

"Pernella" wrote:

before.


"Don Guillett" wrote:

before/after examples??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pernella" <Pernella @discussions.microsoft.com wrote in message
...
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!