Determining how many times an event occur

Hello All,
I have the following problem I can't solve and I decided to ask for your kind help.

I build a monthly table of data that I then process every month, and depending on other calculations I might have an event happening at any given month.
I have indicated the event with an "x" in the example file attached.
What I need to do is see how often the event occurs and determine for that Type and Element a "counter value" for the relative month.
That value is determined as follows, in a time line (in this case starting from January): if an event occurs consecutively, each time the event occurs the counter value for that month increases of one when the event occurs. If an event occur one month and then not the following month, but again on the third month, that as well will increase the counter factor of one when the event occurs. A gap of one single month will not reset the counter to one, a gap of more than one month will. Any consecutive occurrence (as explained before) after the 6th will not increase the counter factor any further, so for example if an event occurs every month in a year then its counter value will have reached the value of 6 for July and it will stay fixed at 6 until December.
Any idea on how could I get the results as in the table on the right in my file?
A formula or even a VBA solution would be great.
Hope I was clear enough, if not let me know

Thanks if you can help