Hi there, I can assist you in “to make a pivot table in order to filter out people who have recorded 3 absences after their last reported attendance and list out their names” the best way & according to your project need. I am an expert and professional in all type data entry, MS excel custom formulas, filtering, pivot tables, charts, sorting, data scrapping from websites, data extraction for multiple excel sheets and consolidating in a central sheet, User forms, Shapes variation etc. I have also handled various excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, it includes extracting information from text files, websites, transferring info in to excel, Data analysis etc.
For more info.
You can see my profile before awarding me your project.
https://www.freelancer.com/u/yadavexpert53
With Regards,
Mohit