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 @
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
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, 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
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, 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
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
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
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
