Inquiry

[Duwin]

I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would like to indicate for inspection if not ok

 

[Duwin]

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

 

[Peter_SSs]

Thanks. What about this one then?

Excel Workbook
	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
Inspect

 

[Duwin]

Thanks. What about this one then?

Excel Workbook
	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
Inspect

Thank you very much peter ��

 

[Peter_SSs]

Thank you very much peter

No problem, glad to help.