I have a sheet of responses to a short survey. The survey asked 4
questions with range answers (1 to 5, 5 being best), and then two
open-ended questions. I would like to count up the number of each
combination of answers with the range answers. So for all of the surveys,
I would like to
How are your survey results stored?Are they separate files?or have you already
combined them into one workbook?
What *I* would do would define an array:Results(QuestionNo, QuestionVal)
Dim Results(1 to 4,1 to 5)
Then, go through your surveys and increment the array value for each
questionThat is
Paul, That is an excellent idea! All my survey results are on one page of
on workbook. So this should be fairly simple to write.
Thanks!!
Greg Della-Croce
Skype: gdellacroce55
Cell: 407-408-2572
greg_della-cr...@sil.org
"If you assume you know the answer, you will miss having a breakthrough.
I
On Mon, 2/20/17, Greg Della-Croce wrote:
Subject: Re: $$Excel-Macros$$ Counting up the combinations
To: excel-macros@googlegroups.com
Date: Monday, February 20, 2017, 3:42 PM
Paul,
That is an excellent idea! All my survey results are on
one
What's the format of your survey results?
My script "assumes" that the current sheet has three columns:
Survey#, Question, Answer in columns A, B, and C.
It places the summary in columns F:Kwith the header of: Question#, Ans_1,
Ans_2, Ans_3, Ans_4, Ans_5
Sub CountArray()
Dim Results(1 To 4, 1
On Mon, 2/20/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Counting up the combinations
To: "excel-macros@googlegroups.com"
Date: Monday, February 20, 2017, 4:50 PM
What's
the format of your survey results?
My
On Mon, 2/20/17, martinez.david533 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Counting up the combinations
To: excel-macros@googlegroups.com
Date: Monday, February 20, 2017, 7:11 PM
On Mon, 2/20/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Counting up the combinations
To: excel-macros@googlegroups.com
Date: Monday, February 20, 2017, 9:23 PM
OK, people, I like a good dialog as much as anyone else. But will you
please stop using this thread for your conversation!
Thanks,
Greg Della-Croce
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
