Forum Discussion

mvargas's avatar
mvargas
Copper Contributor
May 22, 2021
Solved

Creating a discrepancy for schedule

Hello, I am working on creating a user friendly schedule rotating schedule.    I am trying to see how I can create a formula or a way to indicate when I am missing a "rotation" For example, in the...
excel
Formulas and Functions
mvargas's avatar
mvargas
Copper Contributor
May 22, 2021
I meant to take it off as an example. But in this case it would only be the DU
HansVogelaar's avatar
HansVogelaar
MVP
May 22, 2021

mvargas 

Would it be possible to fill all the colored cells with the appropriate letter? Otherwise, you'd need complicated VBA code!

  • mvargas's avatar
    mvargas
    Copper Contributor
    May 22, 2021

    HansVogelaar 

    No because not every spot has to be filled, it is an hourly schedule. 

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 22, 2021

      mvargas 

      Here is an illustration of what I meant. The formula in AL29, confirmed with Ctrl+Shift+Enter, is

       

      =TEXTJOIN(",",TRUE,IF(AO21:AO26,AL21:AL26,""))

       

       

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 22, 2021

      mvargas 

      I meant only the colored cells, for example RG not only in cell AL5, but also in AM5 to AO5.

Resources