Duwin

New Member
Joined
Sep 19, 2019
Messages
15
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
 
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
 
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Thanks. What about this one then?

Excel Workbook
ABC
1101010
2202020
3404040
42800
502828
6353535
729022
8404040
91500
10000
11InspectokInspect
Inspect
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top