Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to pull some info into different sheet?
I don't even know enough about this to know how to ask what I want to know. I
have a spreadsheet to track RC Car Racing. It calculates average number of cars, qualifying and finishing position for each class - I want to be able to pull from this spreadsheet to show each class - for example, have a 2nd sheet (or whatever) that pulls just the m18 rows from the "master" and averages them as well. Example: Date Starting Qualified Finished Class 01/01/05 12 1 1 mini-t 02/04/05 8 2 1 m18 02/12/05 5 2 4 mini-t 03/02/05 10 1 2 touring 03/15/05 7 1 1 m18 8.4 1.4 1.8 |
#2
|
|||
|
|||
Use a Pivot table, they are very powerful and very easy to setup
Use Google to fine an introduction to PT manual on the WEB if you like See attached for a PT with your data (right click on the table to refresh the PT if you change the data) Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep link to info on another sheet if that other sheet i. | Excel Discussion (Misc queries) | |||
vlookup...transferring info from 1 sheet to another.... | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |