Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
SUBTOTAL Function - Work on Filtered Data in Excel
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...

Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet

See how to use the AND and OR functions to test to see which records should be extracted in a Advanced Filter Data Dump on a new sheet.

Got a Question? Ask it Here in the Forum.