Manual Sheet to monitor Arrival and Departure patterns for categories

[Zhang018]

Hi, Im drafting out a manual sheet to monitor arrival and departure per category and I'm having problems with the formula (Row 23-28). I have manually stated the correct answers in Row17-22 just to compare if formula answers are correct.

Screenshot an actual file attached just in case

A friend recommended me to just split the category on different rows instead as a work around (Eg. JENNY will be Row 3 for A, Row 4 for D, Row 5 for H) and have additional rows to add each type per category. But i just thought to check with you guys if you can recommend a solution.

Appreciate it. Thank you.

PS: in addition, the sheet will have more names/rows added in time.


also posted via:
excelguru.ca/forums/showthread.php?8994-Manual-Sheet-to-monitor-Arrival-and-Departure-patterns-for-categories&p=36969#post36969
mrexcel.com/forum/excel-questions/1054584-manual-sheet-monitor-arrival-departure-patterns-categories.html