Selecting Cells

John Davis

New member
Joined
Sep 30, 2011
Messages
8
Reaction score
0
Points
0
Location
Florida
How can I select 3 contiguous cells (A1:A3) then not select the next 15 cells (A4:A15) then select the next 3 cells and so forth for about 6,000 lines. Then delete the content from those cells.

But please show me how to modify this so I can delete for example the content for cells (D4:D19) but not delete contents in (D20:D21). Then repeat that.

Thanks in advance!
 
Put tmp in B1.

In B2 add this formula

=ISNUMBER(MATCH(MOD(ROW(),19),{1,2,3},0))

copy down as far as you want, then filter column B for FALSE and clear column A.
 
How can I delete the conents of the "true" cells but not get rid of the cells themselves? I need to retain the empty cells.
 
Just hit the delete key when they are selected.
 
When I filter by False in the B column, it automatically deletes the cells. How can I get it to just highlight the cells?
 
No, it just hides them. Look at the row numbers.
 
Back
Top