Excel 2007 Indicating if Person was served by both programs withing Reporting Period


I apologize if subject header seems long or eccentric, but I really having difficultly trying to think of a solution for my problem.  I work for a homeless shelter program. My goal is indicate in column H “Visited Both Single and Family Shelters “ if a client visited both single and adult shelters within reporting period with a “Yes” value based on column “Shelter type” and “Client”.
Column “I” is what I would like the result to look like.
If you’re wondering I have to answer how many clients were served in both family and single homeless programs in the reporting period.  I need to show client row details.
Any ideas would be greatly appreciated

Thanks




Visited-Both.xlsx
jbakerstullAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
How do the dates come into play? This formula in H2 copied down will give "Yes" or "No" as required.......but it doesn't take any dates into account

=IF(COUNTIFS(A:A,A2,C:C,"family")*COUNTIFS(A:A,A2,C:C,"single"),"Yes","No")

regards, barry
0
 
jbakerstullAuthor Commented:
Thank you.. Date ranges don't come into play.. I do have questions related to length of participation. ect.. but those are the easy questions.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.