Help required

[Hassan]

Dear All,

I have worksheet and want to delete if the word come in column continious e.g.

A1 B1
C1
Start 12:10
Stop 12:15
Start 13:34
R
Start 13:56 "If Continously Start then 1st start C3 = R
Stop 14:12
R
Stop 14:34 "If Continously Stop then 2nd Stop's C5=R
Start 15:12
Stop 15:34

So if Continously Start then coloumn C =R of first Start and if Continously
Stop then Coloumn C = R of 2nd Stop not first one.

Thanks & Regards

Hassan

 

[Spiky]

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.

 

[Hassan]

Dear Spiky,

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