Filter every 25th record
 

Hi - does anyone know if there is a way to pull from a list of data in Excel
2007 every 25th record? In some cases it may every 10th record, or 50th
record.

I apologize if I'm asking my question in the wrong subgroup of Excel.

Thanks for any suggestions.

Filter every 25th record
 

Helper column =MOD(ROW(),25) and auto-filter by that.
--
David Biddulph

"Tammy" wrote in message
...
Hi - does anyone know if there is a way to pull from a list of data in
Excel
2007 every 25th record? In some cases it may every 10th record, or 50th
record.

I apologize if I'm asking my question in the wrong subgroup of Excel.

Thanks for any suggestions.

Filter every 25th record
 

Thanks so much for answering my post, David! Although I wasn't sure how to
set up a "helper column," I did find the answer to that one from another
post. This was exactly what I needed. Really appreciate your time! Thanks!

"David Biddulph" wrote:

Helper column =MOD(ROW(),25) and auto-filter by that.
--
David Biddulph

"Tammy" wrote in message
...
Hi - does anyone know if there is a way to pull from a list of data in
Excel
2007 every 25th record? In some cases it may every 10th record, or 50th
record.

I apologize if I'm asking my question in the wrong subgroup of Excel.

Thanks for any suggestions.

Filter every 25th record
 

Glad it helped.
--
David Biddulph

"Tammy" wrote in message
...
Thanks so much for answering my post, David! Although I wasn't sure how to
set up a "helper column," I did find the answer to that one from another
post. This was exactly what I needed. Really appreciate your time! Thanks!

"David Biddulph" wrote:

Helper column =MOD(ROW(),25) and auto-filter by that.
--
David Biddulph

"Tammy" wrote in message
...
Hi - does anyone know if there is a way to pull from a list of data in
Excel
2007 every 25th record? In some cases it may every 10th record, or 50th
record.

I apologize if I'm asking my question in the wrong subgroup of Excel.

Thanks for any suggestions.