Help required
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 |
Help required
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. |
Help required
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. |
All times are GMT +1. The time now is 08:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com