I have a table that lists observations completed over the course of the year.
If someone goes three consecutive months without completing an observation, I would like an "R?" to appear to the right of the table. (this will remind me to retire the person)

One issue I can see is the months ahead of now (May-Dec) that are also empty may cause problems.
I've attached the dummy sheet

dummy7.xls