D
Deborah
I have a worksheet with 716 rows I need to select every 17th row. How do I
do that?
do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Helper column with the formula =MOD(ROW(),17), and autofilter by that?
D
Deborah
Thank you.
David Biddulph said:Helper column with the formula =MOD(ROW(),17), and autofilter by that?
D
Deborah
David I must be really uneducated but can you give me step by step?
R
Roger Govier
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.
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.
T
Tammy
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!
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!
R
Roger Govier
You're very welcome, Tammy.
Glad you found it useful and thanks for letting us know.
Glad you found it useful and thanks for letting us know.