League Stats Workbook

eslusk

New Member
Joined
Jul 13, 2007
Messages
12
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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top