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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.