BS: Excel help please

Subject: BS: Excel help please
From: GUEST,Red Eye
Date: 24 Feb 05 - 12:08 PM

I am trying to formulate a table for my football clubs six a side event. We have decided to go hi-tech this year and create a computerised version of league tables.

Can anyone explain (or even do) an excel table that will create the amount of games played, won, drawn, lost, goals for and goals against with a points value at the end. I know that some of you are very experienced in this field and would appreciate some help and direction.

Kind Regards

Tom.

Subject: RE: BS: Excel help please
From: Mr Red
Date: 24 Feb 05 - 02:06 PM

Excel expert right here. The only problem is my excel went into overload and despite the re-install still crashed-out. This happened just today.

The easiest way to start is to put text in cells - vertically, team after team.
Anf other datat horizontally. Leave the top row for a header explanation.

After that it gets complex bu PM me whe you have a list of 10 with all the columns for the other data. Or webmail me from my website

Subject: RE: BS: Excel help please
From: gnu
Date: 24 Feb 05 - 02:19 PM

Cool site. Saved for further exploration. Thanks.

Subject: RE: BS: Excel help please
From: Mr Red
Date: 24 Feb 05 - 06:10 PM

There are a few Excel files on that and my personal site. VBA cells you name it.

Still no joy with Excel crash, I just discovered Outlook uses Outlook Express - can't e-mail without it. And it got a whole lot messier at one point, and still no solution.

Subject: RE: BS: Excel help please
From: GUEST,Red Eye
Date: 25 Feb 05 - 08:21 AM

Did you get my web mail?

Subject: RE: BS: Excel help please
From: GUEST,red eye
Date: 26 Feb 05 - 01:37 AM

Anyone else help??

Subject: RE: BS: Excel help please
From: Rasener
Date: 26 Feb 05 - 04:39 AM

I used to do something like what you want to do. If I remeber right, I used if statemenets to work the points out based on the results.

pm me with your e-mail address and I will send you some spreadsheets I designed for students to learn how to do if statemenets.

Les

Subject: RE: BS: Excel help please
From: Red Eye 1
Date: 16 Mar 05 - 10:31 AM

May I through this forum thank the successful efforts of The Villian to resolve the Excel problem we were having.

Much appreciated.

Regards

Tom

Subject: RE: BS: Excel help please
From: Mr Red
Date: 16 Mar 05 - 06:53 PM

The answer is no I didn't get a webmail but glad you got the solution.

I found a problem with the webmail which involves IE versions before 5 (I think) in which case I suggest the dance page has another link to a simpler page. It is all about Spam prevention.

Subject: RE: BS: Excel help please
From: Rasener
Date: 17 Mar 05 - 09:54 AM

You are welcome Redeye :-)