Need help for a formula to count how many consecutive non-zero months in a year but count resets after each 3 consecutive months is achieved.
eg1: if all months value >1, count as 4 consecutive 3-months block.
eg2: 1,1,0,1,1,1,1,0,0,1,1,1 = count as 2 consecutive 3-months block.
eg3: 1,1,1,1,1,0,1,1,1,1,1,1 = count as 3 consecutive 3-months block.
eg1: if all months value >1, count as 4 consecutive 3-months block.
eg2: 1,1,0,1,1,1,1,0,0,1,1,1 = count as 2 consecutive 3-months block.
eg3: 1,1,1,1,1,0,1,1,1,