Dear Spiky,

Thanks for reply, I want, if two START then remove first Start and If two
STOP then remove second Stop.


"Spiky" wrote:

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.