Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP ABOUT FUNCTIONS
Hi Saky,
Best solution is to create a pivot table ( Data Pivot Table ) and follow instructions ... HTH Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP ABOUT FUNCTIONS
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions |