Need help with multiple complex formula sheet

[Alexg1589]

Hello,

Have been working on this monstrosity for a while with numerous changes. We want to track contractors that come on board to us in the organization and track how much we spend on them. We have multiple variables and the formulas got tacked on to track employees who were planned within the budget (green) and who were unplanned (red). Now the next wrench that was tossed to me was that some contractors get on board with us and we budget them towards that certain reason. Sometimes those contractors leave before the end of term and we want to track when even though the month was budgeted it was unfilled. So I guess what I am looking for is to have an addition to my formula Column N & O that will piggy back off of Column L & M and if two of them dont match then the timeline will show up as unfilled for the months that the contractor is not there. I showed examples in rows 19 and 3. If anyone can help I will be forever in your debt.

Thank you

[nigelbloomy]

I remember this one. This formula in R3 should work. You will have to color code "unfilled" if you want to.

Please Login or Register  to view this content.

[Alexg1589]

Thank you so much!!

[nigelbloomy]

If it works, I accept your offer to be forever in my debt. That was a crazy formula to come up with. Tell your managers to stop adding more requirements.