I'm coding a complex survey where I've got old household members (baseline) and potentially new members - I've sorted that out BUT the only way I can seem to get a list of school aged children I have to go through a series of counts and select alls to generate the list without any blanks. This way works but it's vey time consuming for my data collectors. If I use the child count filter it doesn't account for age just takes the first roster members. Is there another - faster way - that I can create a roster that is filtered by age?
Example Test.xlsx (46.0 KB)