Removing duplicate data on respective columns

[Wclarke17]

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.

[Bedders]

EDITED so my answer is now based on your actual spreadsheet

 

I'd add a new column in with the following formula.

=IF(RIGHT(B2,2)=C2,1,0)

Then either filter or delete anything that's the same. The formula gets the rightmost 2 characters from the left-hand cell, then compares that to the right-hand cell. If it's the same you get a 1. If it's different you get a 0. Filter or delete the 1's.

Edited August 30, 2018 by Bedders