This one is a doozy for me. I've attached the sample workbook.
I need to take the data that I have and create a list of students that have a grade below 75. That list needs to contain their coach's name, student IDs, student names, class failing (below 75), grade, and teacher's name.
My first page has all the coaches names and the names and IDs of students on their roster.
My second page has a large number of students with IDs, names, grades, class name, and teachers.
My third page is where I'm putting it all together.
A few things -
I need to match the students based on ID, not name.
Not all students names have a coach.
I only need to show grades below 75.
Any and all help is appreciated!!!
New Failure Report.xlsx
Bookmarks