Identify the first set of consecutive values

Hi all,

I've got a dataset consisting solely of 0's and 1's (representing payments made and missed).

I need to 1) locate the first set of three or more consecutive zeros in a row, and
2) return the number of the column immediately before the first zero in that first set of 3+

So for this example data:

1 1 1 0 0 0 0 0 0
1 1 1 1 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 1 1 1 0 0 0 0
1 1 0 0 0 1 0 0 0

I would expect the following values to be returned by row:
3
4
0
5
2

Any solution needs to be applicable to a set of any size (more rows/columns) and where the data does not necessarily start at cell A1 (manual updating of the cell references in the formula is ok).

I know similar questions have been solved here many times, but I can't seem to adapt the formula successfully for this specific purpose.

Many thanks for your help.

Perfect - simpler than I thought! Thank you!