Hello,
Trying to find a formula which will find/reference the date when the 12 (twelve) consecutive 0 (zeros) end.
I have numerous rows with numbers distributed by month. Some cells contain >0 zero values. Some 0 values.
I need to identify whether there are twelve consecutive zeros (I already have formula for that -> in picture, if =1, then there are 12 consecutive zeros, if =0, there are no 12 consecutive zeros) and then, identify the month of the last consecutive zero.
Currently used formula : =(SUM(IF(FREQUENCY(IF(D2:AL2<>"";IF(D2:AL2=0;COLUMN(D2:AL2)));IF((D2:AL2="")+(D2:AL2<>0);COLUMN(D2:AL2)))>=12;1))>0)+0
Maybe someone can help? Thanks
Trying to find a formula which will find/reference the date when the 12 (twelve) consecutive 0 (zeros) end.
I have numerous rows with numbers distributed by month. Some cells contain >0 zero values. Some 0 values.
I need to identify whether there are twelve consecutive zeros (I already have formula for that -> in picture, if =1, then there are 12 consecutive zeros, if =0, there are no 12 consecutive zeros) and then, identify the month of the last consecutive zero.
Currently used formula : =(SUM(IF(FREQUENCY(IF(D2:AL2<>"";IF(D2:AL2=0;COLUMN(D2:AL2)));IF((D2:AL2="")+(D2:AL2<>0);COLUMN(D2:AL2)))>=12;1))>0)+0
Maybe someone can help? Thanks