You can build an advanced list of students with the number of their attendance codes using the following parameters:
Objects:
User Base
...Absence
......Excuse Type

Display Fields:
User Base.First Name
User Base.Last Name
User Base.Host ID

Mark the Enable Grouping Options checkbox.
Under Grouping, select Count from the dropdown menu next to User Base.Host ID

Global Filters:
Where Absence.Calendar Date within [Enter date range to search]
And Excuse Type.Excuse any of [Attendance codes to Search]