| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Calculate a sum between a rolling data range.
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
