I am statistician for football team. I have created a list of team stats for the entire team, but am wanting to create separate lists for individual categories such as rushing and receiving, but only include those individual players with at least one attempt. The following is a sample from the team list for rushing yards.
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Player Name[/TD]
[TD]Attempts[/TD]
[TD]Yards[/TD]
[TD]Average[/TD]
[TD]Touchdowns[/TD]
[TD]Longest Rush[/TD]
[/TR]
[TR]
[TD="align: center"]Player A[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]2.7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]Player B[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]185[/TD]
[TD="align: center"]7.1[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]27[/TD]
[/TR]
[TR]
[TD="align: center"]Player C[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]62[/TD]
[TD="align: center"]31.0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]52[/TD]
[/TR]
[TR]
[TD="align: center"]Player D[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Player E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]Player F[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"]8.3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]29[/TD]
[/TR]
[TR]
[TD="align: center"]Player G[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]-2[/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]Player H[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]Player I[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]
To create a list to Rank them by Yards I have tried the following.
cell B12: =IFERROR(LARGE($C$2:$C$10,ROW(1:1)),"")
cell B13: =IFERROR(LARGE($C$2:$C$10,ROW(2:2)),"") ect. Through cell B20.
cell A12: {=IF(LEN(B12),INDEX($A$2:$A$10,SMALL(IF($C$2:$C$10=B12,ROW($1:$9)),COUNTIF(B$12:B12,B12))),"")}
Through cell A20.
RESULT:
[TABLE="width: 200"]
<tbody>[TR]
[TD]Player F[/TD]
[TD="align: right"]216[/TD]
[/TR]
[TR]
[TD]Player B[/TD]
[TD="align: right"]185[/TD]
[/TR]
[TR]
[TD]Player C[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]Player A[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]Player D[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Player I[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Player E[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player H[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player G[/TD]
[TD="align: right"]-2[/TD]
[/TR]
</tbody>[/TABLE]
IS there a way, in which the condition, ATTEMPTS (B2:B10) must be greater than zero, can be added to the formula's in A12:B20 to remove Player E and Player H from the result? (only include players with at least 1 attempt in the result)
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Player Name[/TD]
[TD]Attempts[/TD]
[TD]Yards[/TD]
[TD]Average[/TD]
[TD]Touchdowns[/TD]
[TD]Longest Rush[/TD]
[/TR]
[TR]
[TD="align: center"]Player A[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]2.7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="align: center"]Player B[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]185[/TD]
[TD="align: center"]7.1[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]27[/TD]
[/TR]
[TR]
[TD="align: center"]Player C[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]62[/TD]
[TD="align: center"]31.0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]52[/TD]
[/TR]
[TR]
[TD="align: center"]Player D[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Player E[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]Player F[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]216[/TD]
[TD="align: center"]8.3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]29[/TD]
[/TR]
[TR]
[TD="align: center"]Player G[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]-2[/TD]
[TD="align: center"]-1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]Player H[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]Player I[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]5[/TD]
[/TR]
</tbody>[/TABLE]
To create a list to Rank them by Yards I have tried the following.
cell B12: =IFERROR(LARGE($C$2:$C$10,ROW(1:1)),"")
cell B13: =IFERROR(LARGE($C$2:$C$10,ROW(2:2)),"") ect. Through cell B20.
cell A12: {=IF(LEN(B12),INDEX($A$2:$A$10,SMALL(IF($C$2:$C$10=B12,ROW($1:$9)),COUNTIF(B$12:B12,B12))),"")}
Through cell A20.
RESULT:
[TABLE="width: 200"]
<tbody>[TR]
[TD]Player F[/TD]
[TD="align: right"]216[/TD]
[/TR]
[TR]
[TD]Player B[/TD]
[TD="align: right"]185[/TD]
[/TR]
[TR]
[TD]Player C[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]Player A[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]Player D[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Player I[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Player E[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player H[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Player G[/TD]
[TD="align: right"]-2[/TD]
[/TR]
</tbody>[/TABLE]
IS there a way, in which the condition, ATTEMPTS (B2:B10) must be greater than zero, can be added to the formula's in A12:B20 to remove Player E and Player H from the result? (only include players with at least 1 attempt in the result)