I have a spreadsheet set up where I input a lot of data into a raw sheet and need to get some stats off of it. The problem I have is, I don't know how to count correctly. For example, I have a column for Name, Event, Time Start, Time End. In the name column one person will come up multiple times. I have been able to count how many time a name comes up, but what I want to do is count how many times a name comes up but only once per unique event.
Example is attached to the thread.
Basic question:
How do I count the amount of unique events a person has attended?
Worth noting is that there are consistently more rows added by the week or day when events happen.
Bookmarks