I have a sheet where I record episodes of sickness for staff. I want to return the total count of unique people, who have 5 or more individual episodes of sickness. For example, person A might have 5 episodes and person B might have 10 episodes. I therefore need to return the number 2, not 15, as 15 is the overall general count, where as there are only 2 unique people with more than 5 episodes of sickness or more.
I've found some articles online suggesting a combo of ROWS, UNIQUE and FILTER, but I cannot get this to work correctly. Is there another approach or am I missing something?
I've simplified my example in the attached and there are reasons why some of these numbers (e.g. instances) are entered manually...
Bookmarks