Forum Discussion
mvargas
May 22, 2021Copper Contributor
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...
- May 23, 2021
See the attached version.
HansVogelaar
May 22, 2021MVP
Why is C missing? It appears to be in row 4.
mvargas
May 22, 2021Copper Contributor
I meant to take it off as an example. But in this case it would only be the DU
- HansVogelaarMay 22, 2021MVP
Would it be possible to fill all the colored cells with the appropriate letter? Otherwise, you'd need complicated VBA code!
- mvargasMay 22, 2021Copper Contributor
- HansVogelaarMay 22, 2021MVP
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,""))