I am trying to get a formula that will return the following result. If column D shows "Out-of-School" anywhere in the cell, then I want to count the number of unique students that have a resolution stating "out-of-school". For this particular set of data there are 3 unique students that have a resolution of "out-of-school". The problem I have is that the words "Out-of-Town" are only a portion of the cell and using the wildcard asterick doesn't give the correct answer. I am doing the Control-Shift-Enter but getting the result of 0.
<tbody>
</tbody>
Stu | Last | First | Resolution |
594 | Arm | Lance | Loss of Privilege |
567 | West | Kayne | Short-Term Out-of-School Suspension |
567 | West | Kayne | In-School Suspension |
345 | Poe | Amy | Parent Contact/Conference |
105 | Hope | Bob | Student Conference/Warning |
210 | Fey | Tina | Parent Contact/Conference |
224 | Dal | Jeff | Long Term Out-of-School Suspension |
224 | Dah | Jeff | Out-of-School Suspension Pending Hearing |
580 | Kar | Kim | Short-Term Out-of-School Suspension |
52 | Hard | Tonya | Detention |
<tbody>
</tbody>