+ Reply to Thread
Results 1 to 4 of 4

Divide up work evenly

  1. #1
    Registered User
    Join Date
    11-15-2021
    Location
    Gatineau, Canada
    MS-Off Ver
    O365
    Posts
    16

    Divide up work evenly

    Morning,

    I have a spreadsheet with 589 lines of users that have to be contacted. My team is 5 people. I would like those lines divided up as evenly as possible between 5 people (4x118 & 1x 117)

    Is there a formula that would allow me to do that? I've recently been promoted and am in an entirely new role. Excel was minimally used before but is now being heavily relied on and trying to build my skills. This is not someting I've seen in any training videos I've watched.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Divide up work evenly

    Well the row number returns the row number
    mod returns the remainder when divides by a number
    mod(row(a1),5) will return values form 0 to 4 so split into 5 groups.

    However you have no attachment to add it to

    If you wanted you could have
    =VLOOKUP(MOD(ROW(A1),5),{0,"Person 1";1,"Person 2";2,"Person 3";3,"Person 4";4,"Person 5"},2,0)

    where the persons are the persons names

  3. #3
    Registered User
    Join Date
    11-15-2021
    Location
    Gatineau, Canada
    MS-Off Ver
    O365
    Posts
    16

    Re: Divide up work evenly

    Ok so the attachment is a snipit of the file, my team (5 people) will be emailing out 589 people. I would like to break those 589 people into 5 groups, with my
    team members names in a column to identify who is emailing whom.(Team members names are not yet in the spreadsheet.). I can add my team members names somewhere in the sheet.

    Just looking for the easiest and quickest way to accomplish this.

    Hope this helps.
    Attached Images Attached Images

  4. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Divide up work evenly

    Welcome to the forum

    Did you fully consider davsth's response in post #2 ? Here is a little more detail for how to implement his suggestion:

    Pick the column where you want your team members to appear.

    Copy/paste davsth's vlookup() formula from his post #2 into row-2 of that column.

    Copy the formula down to row 589 (at least).

    If that gives you what you are looking for then replace "Person 1", "Person 2" etc. in the formula with your actual team member names.
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu

+ 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. Divide a range evenly across cells given min and max
    By pambree in forum Excel General
    Replies: 4
    Last Post: 01-14-2024, 01:42 AM
  2. Cells auto-divide evenly
    By AlexWhite532 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2020, 07:15 PM
  3. Help me divide shipping volume evenly using cumulative sum...
    By DistributionExceller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2013, 02:49 PM
  4. How do I divide the work evenly between teammates
    By Godiva in forum Excel General
    Replies: 4
    Last Post: 07-22-2012, 09:27 AM
  5. divide rows evenly into columns
    By dwrkz in forum Excel General
    Replies: 2
    Last Post: 07-01-2009, 10:34 AM
  6. DIVIDE NUMBERS EVENLY
    By NEYS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2006, 03:48 AM
  7. [SOLVED] Divide numbers and distribute evenly.
    By rhon101 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2006, 09:50 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