Forum Discussion
Last 12 months counting
I am trying to produce a rolling 12 month count sheet that I have attached. In the large part, it works, but as explained in the workbook, sometimes when there is a cell with data that is not counted...
Hello,
No problem. I have been there too before asking similar questions.
I would like binary for 12 months- just have they appeared in the last 12 months or not.
If you could make that work that would be amazing!
No problem. I have been there too before asking similar questions.
I would like binary for 12 months- just have they appeared in the last 12 months or not.
If you could make that work that would be amazing!
Does this do it?
=IF(SUM(Sheet1!C2:N2)>0,"Yes","")
Copied forward; the relative references change to always be dealing with the "most recent twelve months"