HELP ABOUT FUNCTIONS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saky - 21 Oct 2006 16:24 GMT

Hi, im working on Excel Workbook for soccer statistics. I have a litle
problem. I created a sheet on which I'll show statistics and games for
a selected club. A problem is with games for that club. I want to make
a table in which I'll show games for selected club. How to do that?

Reply to this Message

Carim - 21 Oct 2006 16:36 GMT

Hi Saky,

Best solution is to create a pivot table ( Data Pivot Table ) and
follow instructions ...

HTH
Carim

Reply to this Message

Saky - 21 Oct 2006 16:45 GMT

Can you give me some hint's? I try but it seams a little dificult...

>Hi Saky,
>
[quoted text clipped - 3 lines]
>HTH
>Carim

Reply to this Message

Carim - 21 Oct 2006 16:58 GMT

Here is a basic explanation

http://www.homeandlearn.co.uk/ME/mes9p5.html

Carim

Reply to this Message

Saky - 21 Oct 2006 17:05 GMT

Yeah, I got it... But, I don't know how to use this for my problem? I
need to show all games for one club that user choose. So, from a
complete list, I need clubs home and away games, sorted by date...
I don't know how pivot tables can help? They are fine for a financial
report, but for this... I don't know.

>Here is a basic explanation
>
>http://www.homeandlearn.co.uk/ME/mes9p5.html
>
>Carim

Reply to this Message

Pete_UK - 21 Oct 2006 20:32 GMT

Take a look at this for some ideas:

http://www.xldynamic.com/source/xld.LeagueTable.html

Hope this helps.

Pete

> Yeah, I got it... But, I don't know how to use this for my problem? I
> need to show all games for one club that user choose. So, from a
[quoted text clipped - 7 lines]
> >
> >Carim

Reply to this Message