I have an upcoming event where we’re selling tickets to students from the Faculty of Engineering. I need a spreadsheet to manage student names, and I want to filter them by department into separate sheets, so I can track ticket sales for each academic year.
Each academic year is divided into two categories: Old Regulations and New Regulations.
The departments are:
Preparatory
Computer Engineering
Communications Engineering
Electrical Power Engineering
Mechanical Power Engineering
Mechanical Production Engineering
Architecture
Architectural Planning
Civil Engineering
Petrochemicals
Artificial Intelligence (AI)
Mechatronics
Environmental Architecture
Renewable Energy
Construction Engineering
I also need a counter to calculate the number of tickets sold per academic year/category.