I have data from a survey that contains multiple-answer values.

The student can choose up to 18 different answers depending on the
question.

These answers are being entered in a single cell and separated by a
comma, such as 1,3,4,7. For example:

ID Q1 Q2 Q3
1 1,3,4,7 2,4 1,12,18
2 4,5 1,6 1, 7, 9


I am trying to prepare histograms and graphs of the reponses. I've
done this successfully for surveys with single responses, but not with
multiple options.

I have tried to do a frequency function. Excel doesn't want to accept
numbers separated by commas or
spaces as it doesn't count numbers in lists such as above.

I appreciate any help. Thanks!

An Excel worksheet has more than enough cells to accomodate entering
data in multiple cells rather than pounding it all into one cell.

Use datatext to columns to break your numbers out so's you can use
them effectively.


Gord

On Thu, 16 Feb 2012 10:26:50 -0800 (PST), OutdoorRuss
wrote:

I have data from a survey that contains multiple-answer values.

The student can choose up to 18 different answers depending on the
question.

These answers are being entered in a single cell and separated by a
comma, such as 1,3,4,7. For example:

ID Q1 Q2 Q3
1 1,3,4,7 2,4 1,12,18
2 4,5 1,6 1, 7, 9


I am trying to prepare histograms and graphs of the reponses. I've
done this successfully for surveys with single responses, but not with
multiple options.

I have tried to do a frequency function. Excel doesn't want to accept
numbers separated by commas or
spaces as it doesn't count numbers in lists such as above.

I appreciate any help. Thanks!