Microsoft Excel - Pivot Tables

[jmags]

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]

1. Its hard to describe

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]

2. An easy thing to do

is on your pivot table, just copy->paste special->values into a new sheet figure the averages off of that.

[Bertha Venation]

3. Gman's right --

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]

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]

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]

5. I just sent your sheet back to you

check it out and let me know if you have questions. Good luck.

[Rabrrrrrr]

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.