Has anyone got a solution for calculating capped point score per pupil in Excel? So far I've got
but this doesn't take into account the GCSE weighting for equivalencies e.g. if a BTEC subject is in the eighth highest add this twice.
I already have a row with GCSE weighting per subject on it so I almost need to combine the above formula with SUMPRODUCT...somehow?