ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HELP ABOUT FUNCTIONS (https://www.excelbanter.com/excel-worksheet-functions/115484-help-about-functions.html)

Saky

HELP ABOUT FUNCTIONS
 
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

HELP ABOUT FUNCTIONS
 
Hi Saky,

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

HTH
Carim


Saky

HELP ABOUT FUNCTIONS
 
Can you give me some hint's? I try but it seams a little dificult...
:(


On 21 Oct 2006 08:36:06 -0700, "Carim" wrote:

Hi Saky,

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

HTH
Carim


Carim

HELP ABOUT FUNCTIONS
 
Here is a basic explanation

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

Carim


Saky

HELP ABOUT FUNCTIONS
 
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.


On 21 Oct 2006 08:58:07 -0700, "Carim" wrote:

Here is a basic explanation

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

Carim


Pete_UK

HELP ABOUT FUNCTIONS
 
Take a look at this for some ideas:

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

Hope this helps.

Pete

Saky wrote:
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.


On 21 Oct 2006 08:58:07 -0700, "Carim" wrote:

Here is a basic explanation

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

Carim




All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com