Match result point range

It is often important to analyze what is happening on the court during particular moments in a set, for example, in a specific range of points. To analyze these plays, you can use the point range filter that filters the plays that occurred in a particular set moment. You can use it by typing PR after the semicolon, adding the minimum score, and then, after the colon, the maximum score of the range we want to analyze. Below you can see a few examples of how we can use this filter:

1. The formula that counts all attacks after the 20th point:

=VSCOUNT("*A;PR20:*")

2. The formula that counts %kills off all attacks of player number four before the 18th point:

=VSPER("*4A;PR*:18")

3. The formula that counts the efficiency of all attacks of the particular player after the 20th point when the advantage is not higher than two points:

=ROUND(VSEFF(VSCELL("(1)A;PR20:*;PA-2:2",Sheet1!$B$3)),3)

4. The formula that counts all set point and match point attacks:

=VSCOUNT(VSOR("*A;PR24:*;PA-1:-1","*A;PR24:*;PA1:1"))