 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2008Filter
I have a worksheet with 716 rows I need to select every 17th row. How do I do that? Helper column with the formula =MOD(ROW(),17), and autofilter by that? -- David Biddulph >I have a worksheet with 716 rows I need to select every 17th row. How do I > do that? Thank you. > Helper column with the formula =MOD(ROW(),17), and autofilter by that? > -- > David Biddulph > > >I have a worksheet with 716 rows I need to select every 17th row. How do I > > do that? David I must be really uneducated but can you give me step by step? > Helper column with the formula =MOD(ROW(),17), and autofilter by that? > -- > David Biddulph > > >I have a worksheet with 716 rows I need to select every 17th row. How do I > > do that? 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 Data>Filter>Autofilter and use the dropdown on column N to select 0, and you will have every 17th row.  SignatureRegards Roger Govier > David I must be really uneducated but can you give me step by step? > [quoted text clipped - 5 lines] >> >do I >> > do that? 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! > Hi Deborah > [quoted text clipped - 19 lines] > >> >do I > >> > do that? You're very welcome, Tammy. Glad you found it useful and thanks for letting us know. SignatureRegards Roger Govier > Thanks so much for taking the time to write out these steps, Roger. I had > a [quoted text clipped - 31 lines] >> >> >do I >> >> > do that? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.