Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1073Answer.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to extract records (data) from a table using an array formula and how to have dynamic ranges from an Excel Table using Table Formula Nomenclature or Structured References in Data Extraction Array Formulas: 1. (00:33 min) Formula 1: IF, ROWS, INDEX, AGGREGATE, ROW functions and Boolean Math. COUNTIFS too. 2. (08:14 min) Why you should NEVER use IFERROR in Data Extraction Array Formulas. 3. (11:22 min) Conditional Formatting to highlight whole row in data set based on two criteria or two conditions. 4. (12:53 min) Formula 2: IF, ROWS, INDEX, SMALL, ROW functions. 5. (12:53 min) Use Clipboard to gather up formula elements and paste them in any order. 6. (16:38 min) How to create Mixed and Absolute Cell References with Table Formula Nomenclature / Excel Table Feature Structured References in Data Extraction Array Formulas. Formulas To Extract Data with Multiple Criteria: AGGREGATE, SMALL, or Table Formula Nomenclature / Excel Table Feature Structured References. Don't Use IFERROR. INDEX Function, IF, ROW, ROWS functions. Conditional Formatting Row Based On Two Criteria.