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