Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 510
Default HELP ABOUT FUNCTIONS

Hi Saky,

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

HTH
Carim

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 510
Default HELP ABOUT FUNCTIONS

Here is a basic explanation

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

Carim

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I get Excel to determine the line curve formula without graph. Cadelima Excel Discussion (Misc queries) 8 December 20th 05 09:57 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
Database functions should use criteria in formula, as 1-2-3 does 123user Excel Worksheet Functions 8 September 29th 05 08:57 PM
Visible rows and functions that work tracy Excel Worksheet Functions 2 August 19th 05 05:25 AM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"