M
Matthew
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
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