Passing by set

Here you will find the spreadsheet showing you passing numbers by players and by sets.  

In the yellow row, you put the numbers of your passing players.

The formula used here that shows positive passing for the team by set is:

• =VSPER(VSOR("*R+;S1","*R#;S1"))

The formula used here that shows positive passing for the particular player by set is:

•  =VSPER(VSOR(VSCELL("*(1)R+;S1",$B5),VSCELL("*(1)R#;S1",$B5))) ,

for the player, where in cell B5 you put the number of the passing player.