| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter for frist record in a sorted list | Excel Discussion (Misc queries) | |||
| Filter record on color scheme | Excel Worksheet Functions | |||
| Record count in filter mode | Excel Discussion (Misc queries) | |||
| advance filter excluding record | Excel Discussion (Misc queries) | |||
| Why does my advance filter only show one record? | Excel Discussion (Misc queries) | |||
Hybrid Mode
