Thread: Filter
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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?