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 following image. I am missing "DU" and "C".
Any way I can do this?
The numbers next to the Key is how many should be on the hour. I hope this makes sense.
Thanks for all your help!
See the attached version.
16 Replies
As variant
with
=TEXTJOIN(", ",1, IF(COUNTIFS(AL$3:AO$20,AL$25:AL$30)<$AM$25:$AM$30, AL$25:AL$30, ""))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
Why is C missing? It appears to be in row 4.
- I meant to take it off as an example. But in this case it would only be the DU
Would it be possible to fill all the colored cells with the appropriate letter? Otherwise, you'd need complicated VBA code!
