excel pivot help

Job ID: 32771375

Budget: $8 – $15 USD

i need help in some raw data i have on excel that includes huge data amount of attendance sheet and i want to make a pivot table in order to filter out people who have recorded 3 absence after their last reported attendance and list out their names