Hello everyone,
I need help with to process some data.
Data.JPG
Problem 1: Can you please show me I need to use so that i can have result for example, "3" in I6 column (Andrea, Thomas and Nicky counted as "3" even they appear multiple times)
Problem 1.JPG
Problem 2: What formula used to show that on each day, a certain number of name hit either 4 Flags, 3 Flags etc
Problem 2.JPG
Thank you in advance
Bookmarks