Column K counts 'signals', the presence of several criteria being met. Column L indicates two possible outcomes after a signal, depending on subsequent numbers either increasing or decreasing.
Usually column K increases then L returns either a value P or N and at the end the total number of Ps and Ns is equal to the amount of signals. However sometimes K increases again before the criteria in L is met, meaning than the total number of P and N values in L no longer matches K.
Is there any tweak I can make to the formula in K to prevent the value increasing if a P or N hasn't occurred since the last time the count went up by 1? The closest I've been able to get is to suspect that wrapping it in an IF statement that checks whether the current count is equal to the current total of Ps and Ns, but I'm not quite sure how to create this and there may be a better way.
Attached is an example showing this situation occurring.
Thanks for any pointers or advice,
Gareth
Bookmarks