To filter plays by rotation, you use function Z and the number of analyzed rotation. You can use the function VSCELL to automatize it. In cell B2 is the number of analyzed rotation, and in cell A2 number of analyzed player.
The formula for the number of team attacks in a particular rotation is:
=VSCOUNT(VSAND(VSCELL("*A;*Z(1)",$B$2)))
The formula for the number of the player number seven receptions in a particular rotation is:
=VSCOUNT(VSAND(VSCELL("*7R;*Z(1)",$B$2)))
The formula for the percentage of the particular player's positive reception in a particular rotation is:
=VSPER(VSOR(VSCELL("(1)R#;*Z(2)",$A$2, $B$2)))
The formula for the kills of the particular player after reception by a particular player in a particular rotation is as follows:
=VSPER(VSAND(VSCELL("(1)A#;*Z(2)",$A$2,$B$2),VSCELL("*(1)R;B-0",$B$3)))
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article