jmags
(517 posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:10 PM
Original message |
Microsoft Excel - Pivot Tables |
|
Is anyone familiar with creating pivot tables on Excel. I need to find a way to average ACT scores by county...(I have all counties in IL, and each composite score in IL, and need to find a way to average each score by county) I can't figure it out and it's driving me crazy. Anyone out there who can help?
|
Gman
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:13 PM
Response to Original message |
|
Edited on Wed Feb-04-04 09:14 PM by Gman
and what version of Excel?
I wouldn't mind if you emailed it to me and let me look at it. Its easier to do than describe.
If you want, PM me and I'll try to help. Its not that hard, and its real easy to make it harder than it really is.
|
Gman
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:20 PM
Response to Reply #1 |
|
is on your pivot table, just copy->paste special->values into a new sheet figure the averages off of that.
|
Bertha Venation
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:22 PM
Response to Reply #1 |
|
email the spreadsheet to Gman for help. I create pivot tables frequently, but couldn't describe how to do it in writing it to save my ass. Good luck.
|
brainshrub
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:41 PM
Response to Original message |
4. Export the data to Acess and then make a crosstab Query. |
|
It's easier to make Pivot Tables in Access then Excell. (In Acess pivot tables are called "crosstab queries.")
|
Gman
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:52 PM
Response to Reply #4 |
6. Access is much better to work with if you have a very large amount of data |
|
but JMag's sheet only has about 700 rows. So Excel handles it pretty efficienty.
But I agree about Access when I have a ton of data. I've used Access for pivot tables using crosstab queries when I have probably more than 10,000 rows. Access is just a lot better on memory.
|
Gman
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 09:49 PM
Response to Original message |
5. I just sent your sheet back to you |
|
check it out and let me know if you have questions. Good luck.
|
Rabrrrrrr
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Feb-04-04 10:20 PM
Response to Original message |
7. Wow - reading all these posts is like listening to a surgery on the radio |
|
or listening in on the cockpit chatter on a flight.
Kinda cool, but yet also disconnected...
oooooooooooooh.
|
DU
AdBot (1000+ posts) |
Sun May 12th 2024, 06:50 PM
Response to Original message |