paul has attended:
Excel Intermediate course
Excel
when doing a survey with responses which are coded e.g. 1=yes, 2=no, 3=maybe, I want to put all this information into charts/graphs. Could you give me any help with this?
Also, is excel capable of cross tabbing responses from surveys?
RE: excel
Hi Paul,
Thank you for your question.
I assume you would want each question and the count of yes's, no's and maybe's for each question?
You could use a CountIf function:
=countif(Range of cells with the numbers in,criteria such as 1)
e.g. =countif(a6:f16,1)
This will count how many times 1 was entered into that cell range.
Is your data arranged in columns with column headings? If so you could create a Pivot Table.
Please find a link below on how to create a Pivot Table.
http://www.howtogeek.com/howto/6416/how-to-create-a-pivot-table-in-excel-2007/
I hope this helps.
Regards
Simon
