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
 
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

Similar Threads

Need to highlight cells in special order 0
Word VBA for deleting Selected Row 0
Deleting extra rows in Excel 07 2
Inserting rows slow on large report 6
Deleting every nth through every nth row in a column 1
Deleting rows with formulas is very slow 2
Deleting Blank Rows. 3
Update End of Col or End of Row Reference 2

Top