LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide records equally among multiple employees Martin Leffler Excel Worksheet Functions 5 August 28th 06 11:24 PM
Help! Equally spaced cell reference geoff1234 Excel Discussion (Misc queries) 5 July 5th 06 03:23 PM
Sorting data to match existing data Jack C Excel Discussion (Misc queries) 4 May 24th 06 09:48 AM
Check if Equally Divisible John Excel Worksheet Functions 4 April 1st 06 02:10 PM
colors of bar charted data don't follow data after sorting Frankgjr Charts and Charting in Excel 2 January 17th 06 12:33 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"