|
| 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
September 22nd, 2008, 02:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
September 22nd, 2008, 03:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
September 22nd, 2008, 03:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
September 22nd, 2008, 03:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
