HELP ABOUT FUNCTIONS

[Saky]

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?

 

[Carim]

Hi Saky,

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

HTH
Carim

 

[Saky]

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

 

[Carim]

Here is a basic explanation

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

Carim

 

[Saky]

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.

 

[Pete_UK]

Take a look at this for some ideas:

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

Hope this helps.

Pete