Hello gurus, I have a large event dataset for individuals. Below I'm attaching a sample of 10 individuals to give you an idea. Individuals belong to a group and a group consists of one or more individuals. Each individual has one or more event. Each event has one or more episodes within it. Events and episodes have start and end dates. Episodes also have location information. I have to figure out the following: for all individuals that belong to a group that consists of 2 or more individuals, proportion of individual's time spent with any other group member at the same location to the total event duration. In other words, I need to know whether individuals that belong to a group experienced their episodes together (i.e. at the same location on same or overlapping dates) and if yes, the portion of their total event time they spent together. For groups consisting of three or more individuals, I need to figure out the proportion for different combinations of individuals belonging to the same group.
Can this be done using Excel formulas like nested IFs, AND, OR, COUNTIF, etc? Or would I need to learn VBA to be able to do something like this?
Can this be done using Excel formulas like nested IFs, AND, OR, COUNTIF, etc? Or would I need to learn VBA to be able to do something like this?
Last edited: