Solved

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

Posted on 2011-04-20
294 Views

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
Question by:jbakerstull

LVL 50

Accepted Solution

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

Author Comment

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.