Posted to microsoft.public.excel.programming

Melanie[_4_] Melanie[_4_] is offline

external usenet poster

Posts: 1

Need Help Summarizing Survey Results

I have an Excel worksheet that tabulates survey results for about 100 questions.
There are over 100 responses for each question. The responses vary. Some
questions are Agree, Neutral, Disagree, some questions are 1 to 5, some
questions are A to D and there are several more varieties.

I need to summarize the results for each question. For example, Q1: 35 Agree,
15 Neutral, 75 Disagree, Q2: 5-1, 12-2, 37-3, 55-4, 24-5, Q3: 99A, 0B, 2C, 4D,
etc for 100 questions.

Appreciate any and all suggestions!

Melanie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Analyzing survey results	Tina K	Excel Worksheet Functions	6	September 25th 08 06:08 PM
tallying survey results	marcietmp	Excel Discussion (Misc queries)	2	September 12th 07 07:11 PM
Survey Results help	Curt1521	Excel Worksheet Functions	1	December 18th 06 11:16 PM
survey results	[email protected]	Excel Worksheet Functions	1	December 5th 06 11:21 PM
Tabulating Survey Results	Tabulatin Survey results	Excel Discussion (Misc queries)	3	December 13th 04 09:56 PM

All times are GMT +1. The time now is 03:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us