+ Reply to Thread
Results 1 to 3 of 3

Tabulating Survey Results, "Check all that apply", How to do it in Excel 2003

  1. #1
    Registered User
    Join Date
    02-21-2008
    Posts
    2

    Tabulating Survey Results, "Check all that apply", How to do it in Excel 2003

    Hello,

    I am a volunteer at a non-profit and they want to track survey results in an Excel spreadsheet. No problem except that for at least two of the survey questions, the person filling it out can check more than one selection (Check all that apply). One has 15 possible choices, another has more than 15 possible choices.

    We could just put a column for each possible answer, but that means that whoever is tabulating the survey could end up tabing through 30 columns. Is there a way to allow more that one value (up to say 20) in one cell? Or go to a separate sheet? Sort of like a 3rd dimesion in an array. I would assume that they will also want to be able to get a summary, count, of these also.

    Hope this makes sense.

    General info:

    - I am a novice when it come to Excel, though I have done alot of programming
    - This will be implemented on a Excel 2003 SP5 machine
    - My machine where I would like to develop it has Excel 2002 SP3

    Thanks.

    J

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    Even if you get 10 to 15 answers in one cell, how will you analyse them?

    I assume the survey is a paper survey and that manual inputting to excel will occur.

    I think separate columns are called for... and then analyse with a pivot table or otherwise...

  3. #3
    Registered User
    Join Date
    02-21-2008
    Posts
    2
    I understand that putting all the data in one cell would be a mess and either prevent analyzing that data for make it extremely difficult. That is why I asked it there was a way to make someting allong the lines of a 3rd dimension or 'sub-sheet' just for that one cell.

    As for a Pivot table, I have seen them mentioned, and they were someting I was going to look into, but have not yet. Note the comment about my being a 'novice'.



    Thanks

    J-and-J

    p.s. I am going to be away from my computer for a few days, so may not respond quickly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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