I'm not sure I completely understand what you need, but maybe this
formula in C3, then copied down the column:
=IF(A3=A2,"R","")

This will identify all the repeats so you can delete those rows. If
you want to automatically delete, you will need VBA code, not just
formulas.