+ Reply to Thread
Results 1 to 4 of 4

need to evenly split a list of names into two other lists

  1. #1
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    need to evenly split a list of names into two other lists

    Please ignore this post and embedded file.
    Attached Files Attached Files
    Last edited by opusarlo; 04-30-2015 at 06:11 PM. Reason: confusing

  2. #2
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: need to evenly split a list of names into two other lists

    Please ignore this post and go to the next one.
    Last edited by opusarlo; 04-30-2015 at 06:11 PM. Reason: verbose, confusing

  3. #3
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: need to evenly split a list of names into two other lists

    I at least got started, but now I am truly stumped. Please take a look at the updated file here and find the tab called "Listerizer". It is the last tab. If you open it you will see I started a mod column to split the names into 2 column, but then I realized that would make them 2 equal columns. There will be times when I need to give more patients to one nurse. If Sequoia has 3 patients, Dawn has 6, and Coast has 5 I would want to send 4 of Coast's patients to the Sequoia list and 1 of them to the Dawn list. I think there will have to be a second step here, but I cannot see it.

    Fertig2.xlsm

  4. #4
    Forum Contributor
    Join Date
    08-28-2013
    Location
    grand rapids, michigan
    MS-Off Ver
    Excel 2010
    Posts
    163

    Re: need to evenly split a list of names into two other lists

    I have tried to simplify this thread. Hopefully it helps to get some responses.

+ 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. Replies: 5
    Last Post: 03-26-2015, 01:40 PM
  2. How to Split a number in one cell evenly over several?
    By 975873 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2015, 07:55 AM
  3. [SOLVED] Evenly split number over an array
    By zjabjab in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2015, 05:33 AM
  4. Split an amount evenly with condition
    By JustM3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2014, 09:43 AM
  5. Replies: 5
    Last Post: 05-21-2010, 04:34 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