Filter every nth record within a worksheet...

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Hi,

In the past, I have used the Data/Filter/Advance Filter tool to get
unique records based on text in a column. Is there a simple way to
obtain the nth rows in a worksheet? For example, I wish to display the
4th, 8th, 12th, 16th, etc. rows. Or perhaps the 3rd, 6th, 9th, 12th,
etc rows only.

I thought if I could specify a criteria, this might work but I don't
know how to approach this task. Thanks in advance for any help you can
provide.

-Greg
 
I use a helper column and Data|filter|autofilter.

I use a formula like:
=mod(row(),4)
Or
=mod(row(),3)

Then filter to show the 0's, 1's, ...
 
Hi Greg,

Another way is to use a helper column to extract your data.
With your data in A put this in B1 and drag down.
=OFFSET(A$1,(ROWS($1:1)-1)*4+3,,)
will extract every fourth value

=OFFSET(A$1,(ROWS($1:1)-1)*3+2,,)
will extract every third value

=OFFSET(A$1,(ROWS($1:1)-1)*2+1,,)
will extract every second value

HTH
Martin
 
Hi Dave,

Thanks, this is exactly what I wanted. I didn't know where I was
suppose to place the MOD formula.

-Greg
 
Hi Martin,

I appreciate your recommendation. It's now quite what I'm looking for
but may come in handy for something I need to do at a later time.

Best regards,
Greg
 
Back
Top