i'm very stuck.

i have a workbook that is a list of shops and their audit scores for
the last 24 months.

each store gets at least 1 audit % score every qtr could be 2 or 3
though.......

so imagine the sheet.

650X24

what i am looking for is an easy way of finding if.

the store is CURRENTLY sat on 3 consecutives audit scores of less
that 76%.

if the store has had a period of more than 3 audits of less than 76%
and is now better than 76%

The stupid thing is I can do this the hard way (ie pen and paper) but
I can not do it with XL..

I'm feeling thick so please help me....

either macro or nice formular which ever works


Thanks

Mathew