| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
delete every nth row in selected range
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 top select rows manually for deletion. Is there a way to automate this process? -- cwinters ------------------------------------------------------------------------ cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386 View this thread: http://www.excelforum.com/showthread...hreadid=384995 |
|
#2
|
|||
|
|||
|
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. "cwinters" wrote: 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 top select rows manually for deletion. Is there a way to automate this process? -- cwinters ------------------------------------------------------------------------ cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386 View this thread: http://www.excelforum.com/showthread...hreadid=384995 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
| How can you change the color of the selected range? | Excel Discussion (Misc queries) | |||
| delete columns and rows-cells equalling zero or any selected value | Excel Worksheet Functions | |||
| How to delete the print range | Excel Discussion (Misc queries) | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Linear Mode
