| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Rows
Use a helper column with =MOD(ROW(),5)=1, and filter by that.
-- David Biddulph "bk2003" wrote in message ... I would like to keep every 5th row (i.e. rows 1, 6, 11, 16) "edvwvw via OfficeKB.com" wrote: bk2003 wrote: Is it possible to delete rows by the row number and not by the data inside? I have 300,000 rows and only want to keep 1 of every 5 rows. Which rows do you wan to keep? edvwvw -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to delete all even rows? | Excel Discussion (Misc queries) | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
