Good day everyone...
I am still trying to get my player stats workbook up and running and have a quick (?) question for you all....
Within my workbook, I have 18 worksheets:
14 Weekly Worksheets
1st Half Worksheet (Weeks 1 thru 7)
2nd Half Worksheet (Weeks 8 thru 14)
1 Standings Worksheet
1 Quality Points Worksheet
My question pertains to the 1st Half & Quality Points Worksheets...
I have 5 columns on the 1st Half Worksheet that lists quality points for every individual participating this season.
Column A: Player Name
Column H: Low Tons
Column I : High Tons
Column J: 3IB's
Column K: Tom Tons
Column M: Low Dart Game
I have four divisions, 16 players per division, mixture of male/female...
What I would like to do, on my Quality Points worksheet, is to list the division leaders in each of the fields...These stats often change every week, and I would like for this to be auto generated.....
As an example:
Col A22 Eddie L
Col H22 12
Col I22 01
Col J22 06
Col K22 04
Col M22 19 darts
Col A23 Paul B
Col H23 04
Col I23 00
Col J23 08
Col K23 02
Col M23 25 darts
Col A24 Mike C
Col H24 05
Col I24 04
Col J24 02
Col K24 03
Col M24 24 darts
Col A25 Dan R
Col H25 03
Col I25 01
Col J25 03
Col K25 09
Col M25 27 darts
With the above player stats....The following would be listed on my Quality Points Worksheet:
Most Low Tons
Eddie L
12
Most High Tons
Mike C
04
Most 3IB's
Paul B
08
Most Tom Tons
Dan R
09
Low Dart Game
Eddie L
24 darts
The only problems I can see, is what to do if their is a tie within the division for one of the achievements....I have plenty of room on the Quality Points Worksheet and I'm always open to suggestions on how to lay this out.....Possibly list top 5 per? Or...
Any help would be appreciated....I could send a copy of the workbook to you if you request it..
Thank you,
EL
I am still trying to get my player stats workbook up and running and have a quick (?) question for you all....
Within my workbook, I have 18 worksheets:
14 Weekly Worksheets
1st Half Worksheet (Weeks 1 thru 7)
2nd Half Worksheet (Weeks 8 thru 14)
1 Standings Worksheet
1 Quality Points Worksheet
My question pertains to the 1st Half & Quality Points Worksheets...
I have 5 columns on the 1st Half Worksheet that lists quality points for every individual participating this season.
Column A: Player Name
Column H: Low Tons
Column I : High Tons
Column J: 3IB's
Column K: Tom Tons
Column M: Low Dart Game
I have four divisions, 16 players per division, mixture of male/female...
What I would like to do, on my Quality Points worksheet, is to list the division leaders in each of the fields...These stats often change every week, and I would like for this to be auto generated.....
As an example:
Col A22 Eddie L
Col H22 12
Col I22 01
Col J22 06
Col K22 04
Col M22 19 darts
Col A23 Paul B
Col H23 04
Col I23 00
Col J23 08
Col K23 02
Col M23 25 darts
Col A24 Mike C
Col H24 05
Col I24 04
Col J24 02
Col K24 03
Col M24 24 darts
Col A25 Dan R
Col H25 03
Col I25 01
Col J25 03
Col K25 09
Col M25 27 darts
With the above player stats....The following would be listed on my Quality Points Worksheet:
Most Low Tons
Eddie L
12
Most High Tons
Mike C
04
Most 3IB's
Paul B
08
Most Tom Tons
Dan R
09
Low Dart Game
Eddie L
24 darts
The only problems I can see, is what to do if their is a tie within the division for one of the achievements....I have plenty of room on the Quality Points Worksheet and I'm always open to suggestions on how to lay this out.....Possibly list top 5 per? Or...
Any help would be appreciated....I could send a copy of the workbook to you if you request it..
Thank you,
EL