1. ## 3 consecutive

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

2. Take your data to A1. There are no empty cells. Try this ARRAY formula (finished with Ctrl+Shift+Enter)
This formula counts three consecutive zero numbers.
Code:
`=IF(MAX(FREQUENCY(IF(A1:J1=0;COLUMN(A1:J1));IF(A1:J1<>0;COLUMN(A1:J1))))=3;TRUE;FALSE)`

3. Originally Posted by navic
Take your data to A1. There are no empty cells. Try this ARRAY formula (finished with Ctrl+Shift+Enter)
This formula counts three consecutive zero numbers.
Code:
`=IF(MAX(FREQUENCY(IF(A1:J1=0;COLUMN(A1:J1));IF(A1:J1<>0;COLUMN(A1:J1))))=3;TRUE;FALSE)`
I tried the formula and I知 getting an error, I知 attaching the pictures so you can see.

Also I need the formula to start looking for 3 consecutive zeros after a number greater then zero appears in one of the cells prior.
For example:
0,0,0,0,0,0,6,0,7,8 (this would be false)
0,0,0,0,0,0,6,0,0,0 (this would be true)

Sent from my iPhone using Tapatalk

4. You are missing a closed Parens ie. ) in your formula and it appears that you have not clicked on Control Shift Enter to make it an array formula as instructed.

5. @chtris
Hi and welcome
Also, please do not copy paste images in posts, but attach the worksheet. Pictures cannot be worked with.
Thanks

6. Originally Posted by chrisl614
I tried the formula and I知 getting an error, I知 attaching the pictures so you can see.
Please see my signature. Maybe it's a delimiter problem.
See attached file.

7. ## 3 consecutive

Seems to be close to work but the formula might need some tweaking. Take a look at the file. (I appreciate the help)
I can稚 upload the file through my iPhone (only pictures and I was having a hard time logging into the forum on my pc) I知 attaching an image for now so you can see what I知 talking about

I've attached the file

10. ## 3 consecutive cells of the same value

Try new solution in attached file.
Did it help?

Page 1 of 2 1 2 Last

#### Posting Permissions

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