+ Reply to Thread
Results 1 to 4 of 4

Call Rotation Help

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Call Rotation Help

    I'm trying to create a formula/function to replicate a fairly simple call schedule. I've attached a spreadsheet with an example of what I have so far. I've found a way to automate the rotation, but I'm having trouble figuring out how to automate the weekends. Only one person from the two person team should be on call for each weekend. I need it to rotate back and forth each time that team gets a weekend between the two who are on call. Hopefully that makes some sense.

    I would appreciate any help. Thanks in advance.

    Call Rotation.xlsx

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call Rotation Help

    Okay these 2 are a bit long, but they do the trick:
    E3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    F3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag both down as far as needed
    Note- I revised your rotation formula to one index statement instead of 4 nested IF's

    (see attached)

    Hope this helps
    Attached Files Attached Files
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Registered User
    Join Date
    03-22-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Call Rotation Help

    Thanks. This is perfect. This should save me a ton of time in the future. I like the index method better than my 4 nested IF statements as well. I appreciate your help and time.

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Call Rotation Help

    you are welcome

+ 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. Server Rotation
    By KSM244 in forum Excel General
    Replies: 0
    Last Post: 11-04-2013, 07:53 PM
  2. shiftwork rotation
    By phuongtran in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2012, 06:25 AM
  3. on call rotation calender
    By SUPERFARMAND in forum Excel General
    Replies: 1
    Last Post: 12-23-2008, 05:28 AM
  4. rotation of fields
    By whatswhat1 in forum Excel General
    Replies: 1
    Last Post: 10-27-2006, 03:32 PM
  5. [SOLVED] rotation schedule
    By sam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2006, 07:45 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