# Thread: Inquiry Thanks: 0 Likes: 0

1. ## Re: Inquiry

Originally Posted by Peter_SSs
If we have the same data how is the requirement different?

What do you mean by "consecutive cells are not yet zero"?

Perhaps we do need a couple more sets of sample data and the results?

Sample:

A1 10
A2 20
A3 40
A4 28
A5 0
A6 35
A7 29
A8 40
A9 15
A10 0

In this sample it must say "Inspect" because there is a cell with equal OR greater than 35 and its consecutive cell is not a zero value yet.

However in this sample

A1 10
A2 20
A3 40
A4 0
A5 28
A6 35
A7 0
A8 40
A9 0
A10 0

It must say "ok" because after the cell with equal or greater than 35 the nect value is 0 already. Thanks in advance

2. ## Re: Inquiry

Inspect

 A B C 1 10 10 10 2 20 20 20 3 40 40 40 4 28 0 0 5 0 28 28 6 35 35 35 7 29 0 22 8 40 40 40 9 15 0 0 10 0 0 0 11 Inspect ok Inspect

 Cell Formula A11 =IF(COUNTIFS(A1:A9,">=35",A2:A10,"<35",A2:A10,">0"),"Inspect","ok")

Excel tables to the web >> Excel Jeanie HTML 4

3. ## Re: Inquiry

Originally Posted by Peter_SSs
Inspect

 A B C 1 10 10 10 2 20 20 20 3 40 40 40 4 28 0 0 5 0 28 28 6 35 35 35 7 29 0 22 8 40 40 40 9 15 0 0 10 0 0 0 11 Inspect ok Inspect

 Cell Formula A11 =IF(COUNTIFS(A1:A9,">=35",A2:A10,"<35",A2:A10,">0"),"Inspect","ok")

Excel tables to the web >> Excel Jeanie HTML 4
Thank you very much peter ��

4. ## Re: Inquiry

Originally Posted by Duwin
Thank you very much peter