delete every nth row in selected range


C

cwinters

I have a table for which I'd like to delete every 3rd row of data.
Given that it is 1000's of rows long it would take a very long time to
select rows manually for deletion. Is there a way to automate thi
process
 
Ad

Advertisements

G

Guest

Insert a column.

Enter =mod(row(),3)
COpy down.
Use Autofilter to filter all of the data and select the value that you want.
Delete all the rows with that value.
Clear the autofilter.
Delete the "helper" column.

Come back if that doesn't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top