I have a 2 column list of datetimes and values from a network log. I need to be able to count the occurrences in the list where 4 values occur next to each other vertically greater than 1000.

I think I could do this in VBA by stepping through the array (for i in B:B) but I am looking for a way to have this as a formula instead.

example:
datetime(A) value(B)
10/9/12 7:02 PM 65
10/9/12 7:03 PM 71
10/9/12 7:04 PM 66
10/9/12 7:05 PM 72
10/9/12 7:06 PM 69
10/9/12 7:07 PM 2571
10/9/12 7:08 PM 1580
10/9/12 7:09 PM 78
10/9/12 7:10 PM 1417
10/9/12 7:11 PM 3560
10/9/12 7:12 PM 73
10/9/12 7:13 PM 87
10/9/12 7:14 PM 68
10/9/12 7:15 PM 2975
10/9/12 7:17 PM 36803
10/9/12 7:17 PM 3202
10/9/12 7:18 PM 7289
10/9/12 7:19 PM 192
10/9/12 7:20 PM 9257
10/9/12 7:21 PM 75
10/9/12 7:22 PM 3099
10/9/12 7:23 PM 83
10/9/12 7:24 PM 93

there should be only a count of 1 in this example because 4 consecutive values > 1000 occurs only once from 7:15 to 7:18.

Can someone point me in the right direction?

Thanks for your time.