[Solved] Array Count help (newbie)

[zaoth]

Hi,

I have an array of 300 respondents and their answers to 5 questions.

Basically what I want to do is output next to the respondent number how many times they said X across all questions, for example Person 1, 2. Person 2, 4.
This is what my array looks like so far, I have it being output just as a check that it works.

Please Login or Register  to view this content.

A countif is probably needed or something along those lines with a loop. I have no idea what to do next. I have looked up countif's and they just use the formula but I would like to do it in the VBA code.

Here is a Sample: sample.xlsm

Thanks.

[Vikas_Gautam]

provide a sample workbook....
That will help us to help you better...




Don't forget to click *

[zaoth]

provide a sample workbook....
That will help us to help you better...




Don't forget to click *

Added a sample now. Thanks for the quick reply.

[Arkadi]

Suggestion....

dim these two to use as one dimensional array of x per user, and counter for a loop:

Please Login or Register  to view this content.

then loop through the users to store their "X"'s:

Please Login or Register  to view this content.

What you do with that info afterwards is up to you, but you can loop through users with another for loop....

Please Login or Register  to view this content.

[zaoth]

Suggestion....

dim these two to use as one dimensional array of x per user, and counter for a loop:

Please Login or Register  to view this content.

then loop through the users to store their "X"'s:

Please Login or Register  to view this content.

What you do with that info afterwards is up to you, but you can loop through users with another for loop....

Please Login or Register  to view this content.

Thanks for the help. Had to tweak it a bit to get it working properly but your guidance helped!

[Arkadi]

Yeah didn't have your actual sheet to work with, but figured you'd have enough there to work with
Glad it worked out for you, nicely done.

Edit OOOPS! missed you did put in a sample sheet