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.