Hello,
I would like to use Index Match to retrieve a math grade that appears after a certain date a student was enrolled, picking the first one, but also basing it on ID.
I tried =INDEX('Math Grades Only'!E:E, MATCH(Cohort!A2&">=Cohort!D2", 'Math Grades Only'!C:C&'Math Grades Only'!A:A, 0)), but that was just a guess. I have seen documentation online for Index Match with multiple criteria and using greater than separately, but not together.
I also have a list of math grades and would like to choose the best grade for a course for the student. So if the student got a F, F, and then a B in Math 101, to choose the B. Is this possible in Excel? It would also require multiple criteria.
Any help is appreciated,
Dord25
Bookmarks