Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · Low Priority · Version 2007
Reply Thu 14 Jul 2011, 16:34Delegate paul said...
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?
For upcoming training course dates see: Pricing & availability
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
Fri 22 Jul 2011: Automatically marked as resolved.
|