i want find formula to count consecutive cells matching string (e.g. 1) but the counting of the consecutive cells to start after the 3rd consecutive entry
so if you have on a single row 5 consecutive times number 1 - the result should be 2 because the counting should start after 3rd entry
if you have 8 consecutive entries of number 1 but somewhere between them there is blank cell that should be also considered as single consecutive entry and the result should be 5
attached is example excel file
Bookmarks