I want to delete the all cells from C24:D4469 that has a zero in the Col D D, but the cell in Col C has to be deleted also. Ex C24:D30, delete, skip C31:D32; delete C33:D53, Etc. Can this be done with a formula? Thanks for all suggestions.
FL CASH 3 DIGITS SKIPS.xls | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
24 | EOELHLIOI0 | 0 | 0 | #NUM! | ||
25 | OEELHHIOO0 | 0 | 0 | #NUM! | ||
26 | EEOHHHIIO0 | 0 | 0 | #NUM! | ||
27 | EEOHHLOOI0 | 0 | 0 | #NUM! | ||
28 | EOEHHHIOI0 | 0 | 0 | #NUM! | ||
29 | OEEHHLOOI0 | 0 | 0 | #NUM! | ||
30 | OOEHHLOOI0 | 0 | 0 | #NUM! | ||
31 | EOOHHLOOI0 | 2 | 2454 | 2454 | ||
32 | EEEHHHOII0 | 3 | 1016 | 800.5 | ||
33 | EEEHLLOOI0 | 0 | 0 | #NUM! | ||
34 | EOEHHHIOO0 | 0 | 0 | #NUM! | ||
35 | EOEHLHIII0 | 0 | 0 | #NUM! | ||
36 | EOEHLLOII0 | 0 | 0 | #NUM! | ||
37 | OOEHLLOOI0 | 0 | 0 | #NUM! | ||
38 | OEOLHLIOI0 | 0 | 0 | #NUM! | ||
39 | EOOHHHOOO0 | 0 | 0 | #NUM! | ||
40 | EOOHLHIIO0 | 0 | 0 | #NUM! | ||
41 | OOOLLLOOI0 | 0 | 0 | #NUM! | ||
42 | OOOLLHIIO0 | 0 | 0 | #NUM! | ||
43 | OOOHLLOIO0 | 0 | 0 | #NUM! | ||
44 | EEEHHHOOO0 | 0 | 0 | #NUM! | ||
45 | EEOHLLOII0 | 0 | 0 | #NUM! | ||
ODDEVEN-HIGHLOW-INOUT SKIPS (2) |