Forum Discussion
Match / CountIfs or other?
Is anyone able to help me with a formula that I have been struggling with for some time now. I would like to calculate the value added score across the whole group of learners from their Projected Gr...
Thank you all, I appreciated the help massively.
Follow up question, is it possible to copy a whole row to a new spreadsheet on a single cell critiera?
Something like if any cell in A Column has CF222 copy from this sheet to a different sheet.
Or,
If any cells in F Column has '19 and over' then copy it to anther sheet in the same document?
thanks,