Count occurence between 2 other occurences based on time period
Hi!
Within the column "Subtype", I need to count the number of times "Stadium N2" appears between 2 occurences of the word "REM", only when the time in column "Start" of the second REM occurence is within 15 minutes of the time in column "End" of the first REM occurence.See stars in screenshot: in this case, the count would be 3
What is the formula to do so? Thx