View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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!