Creating a league table in excel

[OB1]

Hi there

I hope somebody can help me with this, as i have tried to get it to
work for about the last 3 years on and off.

I shall explain what i need to know and why to help make it easier for
someone to explain to me what i need to do.

Well, currently, my close family runs a dreamteam (soccer) where points
are given to each person each month blah blah blah.

What i am trying to do is set up a table in excel and have the table
update the positions, i.e. John has 22 points, Laura has 32 points, Joe
has 42 points and Jim has 52 points.

With this information, i have three columns.....

column 1 is titled position, and below that i have 1st, 2nd, 3rd, and
4th (these obviously don't change)

Column 2 is titled Name, and below i want the names, John, Laura, Joe
and Jim

Column 3 is titled points, and below i have the scores 22 pts, 32 pts,
42 pts and 52 pts.

Also the points are next to the appropriate names, i.e. Laura has 32
pts, Joe has 42 pts etc.

What i am after is for the table to update automatically when i punch
the new scores in ( i punch the scores in a different location on the
sheet, and they transfer down to the table), so that if for example
Laura has a good week and has the most points, she would then be shown
top of the league with say 102 pts, and the rest in descending order.

I hope someone can help me, i would be most grateful and appreciative.

Thanks in advance.

Best regards

OB1

P.S. I have attached an xls file with a layout.

 

[OB1]

That would be most helpful Bob, I'd very much appreciate that.

The excel spreadsheet i have attached appears to be there, i have just
tried downloading and opening it and seems fine. It's called Excel
Help.xls at the bottom of my post.

Maybe it is because you haven't registered yet.

Anyways, i look forward to your email, Thankyou.

Best Regards

OB1

 

[Bob Phillips]

Sorry, I mean my anti-virus filters it so I don't get unsolicited
attachments.

 

[OB1]

Bob, When are you likely to send the league table?

It's just if it's before 5pm (GMT) then could you send it to

(e-mail address removed)

and if after to

(e-mail address removed)

I am eager to get my hands on it.

I have been waiting for a light at the end of the tunnel for 3 years
now.

Best Regards

OB1

 

[Bob Phillips]

I sent it to (e-mail address removed) earlier, but will also send it to
(e-mail address removed)
right this minute.

 

[choppi]

Hi Bob,

I am doing the same thing now....you would mind sending it to me a
well please?


Many thanks.
Chopp

 

[Wenger Boyz]

Hi Bob,

Your Excel league table sounds exactly what I'm after. Can you mail i
to (e-mail address removed).

Many thanks,

Phil

 

[Lakeuk]

If you goto www.winsite.com and do a search for 'football' you find a
football league results spreadsheet for the 2003/04 season, a version
for season 2004/05 should appear later on this week on the same
website.

Dave

 

[no3son]

Perfect, thanks

If you goto www.winsite.com and do a search for 'football' you find a
football league results spreadsheet for the 2003/04 season, a version
for season 2004/05 should appear later on this week on the same
website.

Dave