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) |