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.
 
You must log in or register to reply here.

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

Similar Threads

Deleting every nth through every nth row in a column 1
Copy every nth row 0
Summing every Nth row 5
how can i select every nth row? 4
Paste formula every nth row 1
Deleting nth row or column 1
Selecting every other row to delete or move 1
Summing every nth cell 2

Top