Didn't work. line 4 should be true based off the 3 consecutive zeros after the d9 not before. line 5 should be true based since there are 3 consecutive zeros after c5.
need it to be true only after 3 or more zeros after the first number greater then zero, in the row.  Reply With Quote

2. Originally Posted by chrisl614 Didn't work. line 4 should be true based off the 3 consecutive zeros after the d9 not before.
Look at a new solution.
If this does not help, I give up.  Reply With Quote

3. Thanks! But the formula is still not able to accomplish what I was looking for. It seems like the closest its been is with this formula:

{=IF(MAX(FREQUENCY(IF(A2:J2=0,COLUMN(A2:J2)),IF(A2:J2<>0,COLUMN(A2:J2))))>=3,TRUE,FALSE)}

The only problem with this formula is that it doesnt start looking for zero after the first number higher then zero.

Sent from my iPhone using Tapatalk  Reply With Quote

4. Originally Posted by chrisl614 Thanks! But the formula is still not able ...
Okay, here's another attempt. This is ARRAY Formula
Code:
`=OR(IFERROR(IF(COUNTIF(INDIRECT(CHAR(64+LOOKUP(2;1/(A1:J1>0);COLUMN(A1:J1)))&ROW(A1)&":J"&ROW(A1);TRUE);"=0")>0;TRUE;FALSE);FALSE);IFERROR(IF(COUNTIF(INDIRECT(CHAR(64+LARGE(IF(A1:J1>0;COLUMN(A1:J1));2))&ROW(A1)&":J"&ROW(A1);TRUE);"=0")>=3;TRUE;FALSE);FALSE))`  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•