Microsoft Excel - Pivot Tables - Democratic Underground

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?

Printer Friendly | Permalink | | Top

Gman

(1000+ posts) Send PM | Profile | Ignore

Wed Feb-04-04 09:13 PM
Response to Original message

1. Its hard to describe

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.

Printer Friendly | Permalink | | Top

Gman

(1000+ posts) Send PM | Profile | Ignore

Wed Feb-04-04 09:20 PM
Response to Reply #1

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.

Printer Friendly | Permalink | | Top

Bertha Venation

(1000+ posts) Send PM | Profile | Ignore

Wed Feb-04-04 09:22 PM
Response to Reply #1

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.

Printer Friendly | Permalink | | Top

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.")

Printer Friendly | Permalink | | Top

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.

Printer Friendly | Permalink | | Top

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.

Printer Friendly | Permalink | | Top

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.

Printer Friendly | Permalink | | Top

DU AdBot (1000+ posts)

Thu May 02nd 2024, 07:23 AM
Response to Original message

Advertisements [?]

Top

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators

Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.