Hello,
I was hoping for some assistance with a formula and hope I have explained it properly.
I am currently doing some compliance for work and what they have asked me to do is only mark something as non-compliant when it has not been actioned accordingly.
For example, I have Adherence to XXXX , I would normally just mark this as non-compliant and move on but what they want to see is it first marked non-compliant but when it has been addressed/action that negates the non-compliance and marks it again as compliant. I have tried to come up with something in this excel chart but am totally lost with what formula to use and appreciate any guidance. Cheers
Bookmarks