If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|