| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Check out "PIVOT TABLES" in the Help Menu: They take some "trial and error" to get exactly what you want. But since they use the data from the spreadsheet - your only part is to place the columns and rows so you get the data "you want." Once you have what you want then you can select the DATA area of the PIVOT TABLE to either SUM, COUNT, AVERAGE, etc. "PIVOT TABLE" is located under DATA on the menu bar. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=501388 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
| Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Threaded Mode
