google sheets

Job ID: 37450173

Budget: €8 – €30 EUR

I am looking for someone to help me create an intermediate-level formula in Google Sheets! I already have a template for the project, so I am just looking for someone to help me get the formula working properly. The formula should be able to sort, organize, and analyze the data provided in the template. It should be able to take into account complex data inputs and outputs. The successful candidate should have experience with formulas and with Google Sheets specifically. Please reach out if you can help me get the formula I need created!

FIRST TAB: I have created a database of Students with the selected activities. (COMPLETED)
SECOND TAB: I have created a scheduling for the teachers. (COMPLETED)
THIRD TAB: A Printable version of ONE Activity, with the detail of classes and Groups. (COMPLETED), A summary list of all students listed for that class (INCOMPLETE).
FORTH & FIFTH TAB: An automatic summary of Activities for the students.
Student from 2 institution (WIFI & BFI), to create a printable summary to be paste into the class wall with the summary of student names, activities selected, and details of the activities to be held.

Note: NO VB preferred.

Here's the link of the file (Viewer Mode), If you would like Editors mode, please request.
https://docs.google.com/spreadsheets/d/1Zh_ZSO9fMgFBEzc3_dQi0GmlNf-_uWnnjudLBoUs5gc/edit?usp=share_link

Please do ask any question needed before accepting this task