Filter every nth record within a worksheet...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 22 Apr 2008 03:05 GMT

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

Reply to this Message

Dave Peterson - 22 Apr 2008 03:12 GMT

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,
>
[quoted text clipped - 9 lines]
>
> -Greg

Signature

Dave Peterson

Reply to this Message

Greg - 22 Apr 2008 14:24 GMT

Hi Dave,

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

-Greg

> I use a helper column and Data|filter|autofilter.
>
[quoted text clipped - 22 lines]
>
> Dave Peterson

Reply to this Message

MartinW - 22 Apr 2008 09:15 GMT

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,
>
[quoted text clipped - 9 lines]
>
> -Greg

Reply to this Message

Greg - 22 Apr 2008 14:26 GMT

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

> Hi Greg,
>
[quoted text clipped - 25 lines]
>
> > -Greg

Reply to this Message

Rate this thread: