Dear experts,
my problem:
I have multiple tabs.
They contain grades of my students.
I have different tabs for different semesters.
The first tab contains all grades.
In the example file;
Tab 1 = All grades
Tab 2 = points of a project, grades in column S.
In tab 2 the names are mixed, because students have worked in groups.
I want in tab 1 aka "ALL";cell E3. Grades from student name1.
Based on a comparison of names, because in tab 2 the names are mixed up.
I don't want to use a VBA.
Please help me.
Thank you in advance.
Bookmarks