### Excel Magic Trick 1327

DESCRIPTION See how to create a Formula to Count Words in a Column with Mixed Data: Not COUNTA, but with COUNTIFS with the criteria “*?” (Count Text with One or More Characters) and NOT a [Read More >>>]

### Excel Magic Trick 1326

DESCRIPTION See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query: (00:17) Introduction (01:52) PivotTable & MATCH formula. (08:23) Array Formula with the functions: MATCH, IF, ISTEXT, MODE.MULT, N, N(IF,1 formula [Read More >>>]

### Excel Magic Trick 1325

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]

### Excel Magic Trick 1324

DESCRIPTION See how to extract records with a formula: (00:17) Problem Introduction (01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. [Read More >>>]

### Excel Magic Trick 1323

DESCRIPTION See how to use the CALCULATE function and a Table from the Many Side of a One-To-Many Relationship to allow criteria (filter) to flow from the Many Side to an aggregate calculation on the [Read More >>>]

### Excel Magic Trick 1322

DESCRIPTION See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: (00:16) [Read More >>>]

### Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]

### Excel 2013 Workbooks

Create A New Workbook The following guide will show you how to create a blank workbook. Click the File tab Select New from the left menu Click Blank workbook Add A New Blank Worksheet When [Read More >>>]

### Excel Magic Trick 1320

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Power Query. WORKBOOKS

### Excel Magic Trick 1319

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Two PivotTables. WORKBOOKS