+ Reply to Thread
Results 1 to 3 of 3

Frequency Tables, Categorical Data, Multiple Columns

  1. #1
    Registered User
    Join Date
    09-14-2010
    Location
    Santa Barbara
    MS-Off Ver
    Excel 2003
    Posts
    3

    Frequency Tables, Categorical Data, Multiple Columns

    Apologies if this is covered somewhere in the forum but I just spent a good chunk of time looking for a solution here and on the interwebz and I couldn't find what I was looking for.

    Basically I want to turn a data entry table into a frequency table with multiple columns. IE

    the original data table looks like this

    Person1 Person2 Person 3
    A B A
    A B A
    A B A
    A B A
    A B A
    A B B
    A B B
    A B B
    A B B
    A B B


    and i want this output

    Person1 Person2 Person3
    A 10 0 5
    B 0 10 5

    before the last hour of searching for solutions or answers, i spent an hour jiggering with pivot tables without any success. I also tried using the histogram function in the data add-in pack but that seems to only want numeric data. Lastly, I looked though a ton of pivot table tutorials and none of them seem to be able to tell me how to do this.

    is this something that can be done with pivot tables and i'm just not doing the right things with the fields? The best I've been able to come up with is 3 separate pivot tables that provide a frequency table for each person. There's got to be a way to do this in one step right? The actual data I'm working with has a lot more people and a lot more possible categories besides A and B, and I'll have to be doing this a lot in the future, so it would be nice if I could do it all in one fell swoop.

    Again, thanks in advance for your help and if you want to direct me any links you think would be helpful, that would be great. Thanks again.
    Last edited by quanimal; 09-14-2010 at 04:31 PM. Reason: Solved!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Frequency Tables, Categorical Data, Multiple Columns

    Overthinking this one, I think:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-14-2010
    Location
    Santa Barbara
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Frequency Tables, Categorical Data, Multiple Columns

    That's a Bingo! Works perfectly. Thanks...need to relearn these excel functions.
    Last edited by quanimal; 09-14-2010 at 04:31 PM. Reason: Wanted to clarify that problem was solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1