I am programming a survey using excel. In the survey, a prior module will ask about name and gender for each household member, and I want a following module to select only a female respondent from the member list. I have a value list of household members, but how to filter the value list based on gender? Or, I can also select one person and check if this person's gender is female. That will also work. I don't know how to do this and I would greatly appreciate if someone can help me out!
I am programming a survey using excel. In the survey, a prior module will ask about name and gender for each household member, and I want a following module to select only a female respondent from the member list. I have a value list of household members, but how to filter the value list based on gender? Or, I can also select one person and check if this person's gender is female. That will also work. I don't know how to do this and I would greatly appreciate if someone can help me out!