Excel Forum
Similar Content
Filter While Leaving Original Data Intact in Excel
Tutorial: How to filter in Excel by copying the filtered data to a new location without doing anyth...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...

Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data

Advanced Filter & Logical Formulas to Extract Sample Data. For Audit Samples, see how to extract every 30th record using a logical formula and the Advanced Filter Extract Data Feature.
See how to extract a sample of data using the Advanced Filter Feature with a logical formula. See how to set up the logical formula in a cell with a blank Field Name to Get the Advanced Filter to Extract every 30th Record.

Got a Question? Ask it Here in the Forum.