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,""))

         

         

Resources