Results 1 to 2 of 2

Thread: Formula for weekly rotation of lineup schedule

  1. #1
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit

    Formula for weekly rotation of lineup schedule



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Attempting to automate something currently done with pencil, paper and a calendar.
    Have managed to eliminate the calendar using a formula but having trouble creating the lineup for any given week.
    The attached workbook has what I'm starting with and the results I'm looking for.

    I'm hoping for a formula in cell B4 of the "Starting Point" sheet that can be dragged to fill the rotation schedule.

    The challenge I'm running into is that both the lineup and weeks are numbers but neither uses the number 13 which seems to create a moving target that I just can't hit. My formula to force 13 to 14 has eliminated the 13 but other numbers are being skipped in succeeding rows.
    Your assistance would be greatly appreciated.
    Thank you for your time.

    NoS
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    OK, I left this for a while then came back.
    Simpler than I thought.
    Couldn't stop thinking I needed to involve the original lineup in a formula, but I don't.

    B4 =B$2 and drag across
    B5 =IF(B4+1=13,14,IF(B4+1<42,B4+1,B4+1-41)) drag across and down

    Like they say, KISS (Keep It Simple Stupid)

    Thanks to any one who took the time to look at this question.

    NoS

Posting Permissions

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