Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreading 1 large number evenly into several cells
Hi all,
I am trying to create a mailing organizing spread sheet that automates my groups for bulk mailing. My groups and numbers are Zip Total 1 2 3 4 5 6 moved received 88001 46 11 11 12 12 88005 41 10 10 10 11 88007 18 15 3 88011 28 15 13 88012 12 12 880 22 11 14 3 ABQ 17 15 2 NM 14 15 1 MXD 64 11 11 10 11 11 11 1 Ordering is as follows: Groups can have from 10 - 15 items as per USPS Any Zip having more than will fit in that group (88007) has to have extras moved to the next higher level of sort (880). I am looking for a formula/macro which will divide the total number of items in each zip into groups which meet my requirements. I prefer for groups to remain as small as possible so I was thinking divide the total by 10 and then divide the remainder among those groups. (46/10=4 groups, 2 of those get 1 extra and 2 get 2 extra items.) Just not sure how to accomplish this. Any help would be appreciated. Thank you, Byron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a function that counts the number of cells with information | Excel Worksheet Functions | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
How do I copy a LARGE selection of cells from Excel to powerpoint? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |