Get statistics using excel

Hello,

I’m really having trouble getting functions to work like I need.

As we are making approximately 50000 test shots, I need to get the amount of positive and negative test and continuous positive tests and continuous negative tests as well.


For example:
1 continuous positive tests in row : count 40
2 continuous positive tests in row : count 32
…
30 continuous positive tests in row : amount 2

And same for negative

1 continuous negative tests in row : count 40
2 continuous negative tests in row : count 32
…
30 continuous negative tests in row : count 1



Please take a look at enclosed attachment, I’m sure it will explain what I’m trying to achieve.


Thank you in advance.

See attached.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save