Sep 27 2017
10:18 PM
- last edited on
Jul 25 2018
10:09 AM
by
TechCommunityAP
Sep 27 2017
10:18 PM
- last edited on
Jul 25 2018
10:09 AM
by
TechCommunityAP
Hello, I've looked through the forum and I think I've found the answer but I would love input from those who know Excel. I am trying to determine the true number of people who have employee, goverment (public), or no insurance; the categories should be mutually exclusive but some people responded 'yes' (1, whereas no is 2) to multiple categories. For example, respondents B and D answered correctly in the table below. If they answered yes (1) to Employee, that would supersede any other answer (such as respondent C). If I need to find out how many people answered (1) to employee, whether alone or in combination with some other answer, what would be the best formula? (And could I use that same formula to find out how many people just answered yes to 'public' or 'no'?)
Thank you so much!
Employee | Public | No | |
A | 2 | 2 | 2 |
B | 1 | 2 | 2 |
C | 1 | 1 | 1 |
D | 1 | 2 | 2 |
E | 2 | 1 | 1 |