How to Write Excel Formula to Check for Event A occuring within 24 hours of Event B
If you have Excel 365, try the following formula on H10:
=FILTER($B$10:$B$12,INT(($F10=$B$2:$B$4) * ($G10>=$B$10:$B$12) * ($A$10:$A$12=$E10)),"")
Drag it down to fill the other cells. Adapt the formula to your tables. The formula also assumes that there are no multiples EventBs for the same name during the next 24 hours following EventA.
