The issue I have is that in the given period an employee may qualify for ("bonus A" 12 times and "Bonus B" 3 times) or ("bonus A" 2 times and "bonus B" 6 times) or millions of other combinations thereof...

So I need to return a numeric value for each bonus that will go under a column heading "Bonus A"(Number of times: 3 consecutive months @ 100% O/S), "Bonus B"(Number of times: 6 consecutive months @ 100% O/S).

This is where I believe the difficulty comes, returning a value of 1 for five consective months 100% Overseas. The other thing is it must only count 100% O/S values as there will be many months when there are values of 10%, 25%, etc not credited toward the bonus.

for example-

100, 15, 25, 100, 100, 50, 100, 100, 5, 100, 100, 0, 100, 100, 10

where:
'A' = 0
'B' = 0

or

100, 100, 100, 100, 100, 100, 100, 100, 0, 100, 100, 100, 100, 100, 10

where:
'A' = 1
'B' = 1

or

0, 0, 0, 0, 0, 0, 25, 50, 75, 100, 100, 75, 50, 75, 100, 100, 100, 100

where:
'A' = 1
'B' = 0

Hope this makes a bit more sense now...(sure know I'm confused)

Regards,
David