Hi, i have a question in regards to identifying null or blank answers for questions.
Questions were asked and for some, they were left blanks simply the user did not want to answer that particular question. I have to exclude them to know how many people exactly answered that question.
I have a Worksheet with the followings
Column headers are 1) Numbers, 2) Qns5a, 3)Qns5b, 4) Qns 5c and 5)Qns 5d
lets say there are 6 inputs and total rows are 7.
The cells for 2,3,4,5 are just yes or no questions thus, answers are in yes or no.
My question is, how can i identify those people who did not answer at all? By validating the inputs by rows.
First user input, 1 yes no yes yes no
second, 2 no no no no no
3, yes no no no no
4, no no no no no
5 yes yes no yes no
6 yes no no yes yes
7 no no no no no
as we all can see, if we use filtering on the column, it's easily identified but what if my question is a long list?
I would appreciate if anyone is able to help me with this formula
there is no issue on say identifying those who answered yes for Qns5a or Qns5b by using countif index match "yes" functions
but what about the row? Since it's not just individual row. I would like the formula itself to help me identify although a single row is possible with the above same formula of using countif index match "no" function for row validating.
how can i type the formula so that those 3 who answered all No for the above questions be identified ?
Thank you so much for you guidance
Questions were asked and for some, they were left blanks simply the user did not want to answer that particular question. I have to exclude them to know how many people exactly answered that question.
I have a Worksheet with the followings
Column headers are 1) Numbers, 2) Qns5a, 3)Qns5b, 4) Qns 5c and 5)Qns 5d
lets say there are 6 inputs and total rows are 7.
The cells for 2,3,4,5 are just yes or no questions thus, answers are in yes or no.
My question is, how can i identify those people who did not answer at all? By validating the inputs by rows.
First user input, 1 yes no yes yes no
second, 2 no no no no no
3, yes no no no no
4, no no no no no
5 yes yes no yes no
6 yes no no yes yes
7 no no no no no
as we all can see, if we use filtering on the column, it's easily identified but what if my question is a long list?
I would appreciate if anyone is able to help me with this formula
there is no issue on say identifying those who answered yes for Qns5a or Qns5b by using countif index match "yes" functions
but what about the row? Since it's not just individual row. I would like the formula itself to help me identify although a single row is possible with the above same formula of using countif index match "no" function for row validating.
how can i type the formula so that those 3 who answered all No for the above questions be identified ?
Thank you so much for you guidance
