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.
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
Oh, yes, I missed that
- Neither seemed to work when I applied it. Should I be applying something elsewhere?
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!
It might help if you attached a sample workbook without sensitive/proprietary data.
This is the sample of the schedule.
The only ones that are truly important to know that are covered are the ones that are in the picture in the initial post.
