Consulting

Results 1 to 2 of 2

Thread: Shift pattern conversion

  1. #1
    VBAX Regular
    Joined
    Nov 2018
    Posts
    17
    Location

    Shift pattern conversion

    Hi All,

    For some reason this problem is getting the better of me and i cannot find a way around it.

    I have a column of week numbers, one of the shift and i want to add a column shift the team working at that time. We have a permanent night shift and the other day shifts swap from earlies to lates on alternate weeks.

    No matter what 'AND 'OR 'IF or 'IFS formulas i use i cannot get the result i want. No matter what i search online i cannot even point myself in the right direction

    Week Shift Team
    1 Early A
    1 Lates B
    1 Nights N
    2 Early B
    2 Lates A
    2 Nights N

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Posts
    7,879
    Location
    Assuming "Week" is in row 1

    =CHOOSE(MOD(ROW()-1,6)+1,"N","A","B","N","B","A")
    Capture.JPG
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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