Excel Is Fun

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 Is Fun

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 >>>]

Dueling Excel

Dueling Excel 038

Weekly Report Formula or Pivot Table? DESCRIPTION See Mr Excel and excelisfun take daily transactional data and create Weekly Summary Reports using a Pivot Table (PivotTable) and a series of formulas. Learn about: 1.Formula for [Read More >>>]

Excel Is Fun

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 Is Fun

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 >>>]

Dueling Excel

Dueling Excel 037

Evaluate Text Math VBA, Excel 4 Macro Function, MoreFunc add-in? DESCRIPTION See Mr Excel and excelisfun take math formulas stored as text and evaluate then using three methods: VBA, Excel 4 Macro Function or the [Read More >>>]

Excel Is Fun

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 >>>]