So I tried to use VLOOKUP inside my COUNTIF function to get the name of the respondent from the summary page and look for "yes" answersįrom the corresponding row from the data sheet. I tried doing this manually but I have to add new respondents constantly and maintaining the summary table becomes a mess. On another sheet I have a summary table where I want excel to calculate the percentage of "yes" answers among all questions by each respondent. In one sheet I have a questions listed on the first row and respondents listed on the first column and answers to the questions by the respondents selected via a drop-down list in-between.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |