Hi
I'm looking for some help with a school spreadsheet for tracking pupil progress. Children are leveled in maths from 1c (very low) to 6a, (very high). 1c,1b,1a,2c,2b,2a,3c,3b,3a,4c,4b,4a,5c,5b,5a,6c,6b,6a
I would like to show their progress. So, if they have skipped from 3c to 3b a progress column could show 1. If they go from 3c to 4b the progress column would show 4.
I've attached the spreadsheet with the column I want help with highlighted in yellow
I'd really appreciate the help!
Bookmarks