sorting data equally-

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increased percentage question 6
Sum value between two dates and copy to new cell 6
Sum data in a column if multi creteria met 3
Adding Data from Date Range base on relative dates 1
Calculate Amount Based on Year 3
sum of info in a range based on dates 4
Date formula question 4
Find LAST date when corresponing min value became available 7

Back
Top