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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 22, 2021

mvargas 

As variant

with

=TEXTJOIN(", ",1,
  IF(COUNTIFS(AL$3:AO$20,AL$25:AL$30)<$AM$25:$AM$30,
     AL$25:AL$30,
     ""))
HansVogelaar's avatar
HansVogelaar
MVP
May 22, 2021

SergeiBaklan 

I suspect that the coloring matters, and that the MP in AN8 (with AN8:AO8 colored) and in AL17 (with AL17:AM17 colored) count as 2 * 0.5 = 1

    • mvargas's avatar
      mvargas
      Copper Contributor
      May 23, 2021
      Neither seemed to work when I applied it. Should I be applying something elsewhere?
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 24, 2021

        mvargas 

        It's worth to mention on which version of Excel you are. Most probably you need to use array formulas (Ctrl+Shift+Enter)

        Anyway, HansVogelaar formula shall work.

Resources