[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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
0
jbakerstull
Asked:
jbakerstull
1 Solution
 
barry houdiniCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now