Excel Forum
Similar Content
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...
Sum the Visible Rows from a Filtered List in Excel
Tutorial: How to SUM only the visible rows from a filtered data set in Excel. To do this, we will us...
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




Highline Excel Class 19: Advanced Filter Extract Data 9 Examples


Learn about using Advanced Filter to extract data from an Excel List / Table / Database. See these 7 Advanced Filter examples:
1. Extract data with 1 criteria
2. See how Criteria and Extract areas get Named
3. Extract data with 2 or more AND criteria
4. Extract data with 2 or more OR criteria
5. Extract Unique Records
6. Extract data To Different Worksheet
7. Extract data To Different Workbook
8. Add column with True False Formula
9. Extract data with formula criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.