Is there a simple way to remove data which is in cells on respective columns?
People send through spreadsheets with a students current set and the next cell has their "new set" so we can change that on SIMS. However some students are staying in the same set but staff are still including that in the spreadsheet (it gets tedious very shortly).
I've attached a screenshot to help show what I mean; take a look at the final 4 cells. For the most part, if they've changed set, the staff member has gone to the courtesy of changing the cell colour to yellow, but this isn't always the case as with the final 4 cells.
Thanks in advance.
