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: