Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Deborah
If you add another column to your exiting table let's say your data is in A:M, then it is column N. In N1 enter =MOD(ROW(),17) and fill down column N by double clicking the fill handle twice (the fill handle is the small solid black cross that you see when you hover over the bottom right corner of a cell) This will put the sequence of numbers 1 through 16, then 0 for the 17th row continuing on down the column. Apply DataFilterAutofilter and use the dropdown on column N to select 0, and you will have every 17th row. -- Regards Roger Govier "Deborah" wrote in message ... David I must be really uneducated but can you give me step by step? "David Biddulph" wrote: Helper column with the formula =MOD(ROW(),17), and autofilter by that? -- David Biddulph "Deborah" wrote in message ... I have a worksheet with 716 rows I need to select every 17th row. How do I do that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |