Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
I have a worksheet with 716 rows I need to select every 17th row. How do I
do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
Thank you.
"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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
Thanks so much for taking the time to write out these steps, Roger. I had a
similar question, but hadn't read this post. I received the formula from David, as well, but wasn't sure what a "helper column" was. Before I went back to ask him, I thought I would look at a few more posts to see if it was explained. Your explanation was exactly what I needed, too. Thanks! "Roger Govier" wrote: 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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
You're very welcome, Tammy.
Glad you found it useful and thanks for letting us know. -- Regards Roger Govier "Tammy" wrote in message ... Thanks so much for taking the time to write out these steps, Roger. I had a similar question, but hadn't read this post. I received the formula from David, as well, but wasn't sure what a "helper column" was. Before I went back to ask him, I thought I would look at a few more posts to see if it was explained. Your explanation was exactly what I needed, too. Thanks! "Roger Govier" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |