Hi

Please can anyone help me with this problem.

I have data of results of 1,000 tests either pass or fail. Data expressed
as fail fail pass pass pass pass pass pass fail pass fail etc. etc.

How can I automatically find the No of fails within a rolling 30 test sample
range?

For example how many fails between 1 and 30, and 2 and 31, and 3 and 32, and
4 and 33 and so on to the end of 1,000 tests.

Much obliged to anyone who can help.