My column headings all show a students results (from 1 to 100) except for
column A which shows a students age, just written as a year and month, and by
cross referencing down and across I can see the grade, which I would then
like to input in a cell against the students name on worksheet 2:
0 1 2 3 4 5 6 7 8 etc
5/ 1 E E E E E D D D D
5/2 E E E E E E E D
5/3 E E E E E E E E
etc
If anyone can tell me how to do this, once I have set up the grid I would be
so grateful.