Hello everyone,



Urgent help needed to process some data and I have 2 problems right here. I am required to use formula on the end result table, and not filter function.



Problem 1:

How to show that each day, only a certain number of unique name appears.
Eg: On 3/12/2018, Andrea, Thomas and Nicky appeared, so 3 (as in 3 persons) shows in I6



Problem 2

How to show that on each day, the number of person hit with either 4 flags, 3 flags, 2 flags or 1 flag.
Eg: On 5/12/2018, both Andrea and Nicky hit with 3 flags so 2 (as in 2 person) should appear in M8
Note: A person won't hit same type of Flag on the same date


The set of data and end result table attached.


Any assistance is highly appreciated.
Thank you.

Attached Files

Flags.xlsx (11.2 KB, 14 views)