### Excel Magic Trick 1160

Jump To Next Change In Column: Go To Special, Column Difference DESCRIPTION See how to use Jump To Next Change In Column: Go To Special, Column Difference. Learn the keyboards to do this quickly

### Excel Magic Trick 1159

Extract Unique List For Data Validation List with Power Query DESCRIPTION See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown: (00:08) Problem Set, including showing how complicated Array Formula [Read More >>>]

### Excel Magic Trick 1158

Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013 DESCRIPTION See how to Get Millions of Rows of Data into Excel 2013 for a PivotTable without PowerPivot: (00:10) Problem Setup for Excel [Read More >>>]

### Excel Magic Trick 1157

Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula DESCRIPTION See how to use MEDAIN Function to calculate Mileage Costs at \$0.40 Under or Equal to 10,000 Miles and \$0.25 Over [Read More >>>]

### Excel Magic Trick 1156

Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) DESCRIPTION See how to Count the “N” (New) and “U” (Used) for Each Sale (00:08) Problem Setup (01:08) Two COUNTIFS functions with Mixed [Read More >>>]

### Excel Magic Trick 1155

IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for [Read More >>>]

### Excel Magic Trick 1154

Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) DESCRIPTION See how to Unique Count For Name & Date & Criteria From 3rd Column: (00:08) Problem Setup (00:50) Array Formula. Learn about IF [Read More >>>]

### Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]

### Excel Magic Trick 1152

Formula or Power Query: Cost Report When Product IDs Don’t Match DESCRIPTION See how to create Total Cost Report when Product IDs in transaction table do NOT match Product IDs in Lookup Table: (00:08) Set [Read More >>>]

### Excel Magic Trick 1151

Get Two Tables Into Pivot Table Field List using Excel 2013 DESCRIPTION See how to Get Two Tables Into Pivot Table Field List using Excel 2013 to create a Report based on Revenue from one [Read More >>>]