Forum Discussion
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...
See the attached version.
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.
Thank you for all your help! It worked!