+ Reply to Thread
Results 1 to 2 of 2

divide list into equal parts

  1. #1
    Registered User
    Join Date
    05-04-2006
    Posts
    56

    divide list into equal parts

    Hi,
    Not sure how to approach this. have done some seaching but cant see anything.

    Situation:
    I have a list, say 20 values, with an AGE in common. In the list there may be, say 4 comom Ages (how many days old it is).

    What I'd like to do is:
    Divde the list into equal parts, evenly distributing the AGE profile across the desired division, based on the value of a cell. eg: 2 for two lists, 3 for 3 lists, etc.

    I've attached an xls to illustrate:

    Just not sure where to start on this one
    Attached Files Attached Files

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    If your master list is always sorted by age, this logic will divide the ages as evenly as possible.

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a used parts list?
    By danjstock in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2008, 10:14 AM
  2. Macro - Logical Order
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2008, 07:00 PM
  3. Parts List
    By ExcelNeil in forum Excel General
    Replies: 0
    Last Post: 01-24-2008, 03:59 PM
  4. Divide dollars into three parts
    By bozodog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2007, 08:38 PM
  5. country finder lookup macro
    By theghost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2007, 10:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1