Hello,
I am hoping for some help for my spreadsheet.
I am trying to show pupil progress, using 'sub levels'. I have used a VLOOKUP table for tables with 4a higher than 4b, followed by 4c. Levels go all the way from level 1 to level 6 (6 being highest).
I want to measure pupil progress, and how many 'sub levels' they are away from their table. However, this needs to be done at different points in the year, meaning if cells are blank I want it to track progress up to that point (e.g. if in AUT Term, only count sub levels to there). If the cells are full, I want it to show for the final level (being SUM Term).
I have attached my spreadsheet.
For example:
Cell K3 should show 0, as they have achieved target of 4A, also cell L3 should show Y for meeting target
Cell K4 should show 3, but if G4 is updated, this should change I4 and L4 by SUM, also I4 should currently show -1
Cell K5 should show +1, as they are 3 grades above target, with cell L5 having an E for 'exceeded'
I would like to have formulas in the cell if possible, and not use any 'helper' cells
I hope this is somewhat clear and I really appreciate your help
J
Bookmarks