Excel Forum

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.