I have a row of figures for the last 12 weeks, they are results. I need to count backwards from the most recent week, checking if the result reached target.
This is so I can show how many consecutive weeks a target has been reached.
I've toyed with the idea of a macro to do this, however as we may need to add more weeks I'd rather do it with a formulae?
I know there is countif, however this wont do it consecutively?
Has anyone any pointers?
Thanks.
This is so I can show how many consecutive weeks a target has been reached.
I've toyed with the idea of a macro to do this, however as we may need to add more weeks I'd rather do it with a formulae?
I know there is countif, however this wont do it consecutively?
Has anyone any pointers?
Thanks.