Selecting Cells

[John Davis]

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!

[Bob Phillips]

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.

[John Davis]

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.

[Bob Phillips]

Just hit the delete key when they are selected.

[John Davis]

When I filter by False in the B column, it automatically deletes the cells. How can I get it to just highlight the cells?

[Bob Phillips]

No, it just hides them. Look at the row numbers.

[John Davis]

Ah Ha! Figured it out, thank you for your help.