Event processing, interval processing in Excel

How do you analyze a sequence of event data in Excel (or your spreadsheet of choice) if you are interested only in data that occurs between specific types of events? The method presented tracks the current interval state to help identify which rows are relevant to the analysis.