I have a worksheet with 12 columns.
Column b2:k2 have numbers in them. I need a formula that can provide some kind of indicator when 3 consecutive cells have the number 0 in them after at least one of the cells prior to the 0 have a different number in them.
Example: 0,0,2,0,4,12,1,0,0,0 (this would be true)
0,0,0,0,0,8,9,0,0,8 (this would be false)
Sent from my iPhone using Tapatalk
Column b2:k2 have numbers in them. I need a formula that can provide some kind of indicator when 3 consecutive cells have the number 0 in them after at least one of the cells prior to the 0 have a different number in them.
Example: 0,0,2,0,4,12,1,0,0,0 (this would be true)
0,0,0,0,0,8,9,0,0,8 (this would be false)
Sent from my iPhone using Tapatalk