Creating a league table in Excel

S

Sumisdad

I have created a chart in Excel for a fantasy football league (14 players)

eg Player Aug/Sept Oct Nov etc

Fred 25 25 21

Jim 22 30 22

Harry 20 21 40

Bill 10 14 12



I'm after a 2 tables. One that updates automatically for each month and an
overall end of season table. They will be on two separate pages e.g.



Monthly Winner



Aug/Sept Oct Nov
etc.

1st Fred 25pts 1st Jim 30pts 1st Harry 40pts

2nd Jim 22pts 2nd Fred 25pts 2nd Jim 22pts

3rd Harry 20pts 3rd Harry 21pts 3rd Fred 18pts

4th Bill 10pts 4th Bill 14pts 4th Bill 12pts

etc.



Overall Winner



1st Harry 81pts

2nd Jim 74 pts

3rd Fred 68pts

4th Bill 36pts

etc.

Thanks in advance

Dave
 
S

Sumisdad

Just to let everyone know that I managed to get someone to sort out the
problem. On the football Ng's surprisingly enough.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I create and extract a random order from list in Excel? 5
creating numbered coupons using word and excel mail merge 0
Creating a formula in Macro 2
Sumif banding on a condition 5
Generating points from 2 tables (IF funtion limited) 0
Creating a league table in excel 8
When building a chart Dates are been included that are not in thedate range 2
how to create a chart in excel base on date? 1

Top