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
Bookmarks