Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 4th 06, 05:50 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 23
Default 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
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
a function that counts the number of cells with information zuri125 Excel Worksheet Functions 1 June 7th 06 07:37 AM
Excell-How to add the number of cells containing text? = a sum aruba64taw Excel Worksheet Functions 2 December 21st 05 09:51 AM
How do I copy a LARGE selection of cells from Excel to powerpoint? Deadly Excel Discussion (Misc queries) 2 August 15th 05 03:21 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM


All times are GMT +1. The time now is 07:39 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017