Forum Discussion
Compare Students Grade
How to compare this 2019-20 (table 1) 2020-21 (table 2) A B If 2nd table less than 1st then weak if 2nd table greater than 1st then very good if 2nd table equal to 1st tabl...
Presumably, though, there are names associated with the grades too...and you want to make sure you're comparing John Doe's grades from the two years....
Is it possible for you, shahid20 ,to give us the full structure of the two tables? That formula from OliverScheurich is great for the data you've shared, but I find it hard to believe it's going to be that simple, unless you've already taken care of making sure each row in each table is for the same student.
A* A Below expected
A A Expected
C | A* | Above Expected |
I need help for formula to show the result (Expected, Above Expected and Below Expected) based on two grades compare
Cross-posted at Compare two letter grades
