Excel Is Fun

Excel Magic Trick 1156

August 31, 2015 0

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

Excel Is Fun

Excel Magic Trick 1155

August 27, 2015 0

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

Dueling Excel

Dueling Excel 038

August 26, 2015 0

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

Excel VBA

Excel VBA Do Until and Do While Loops

August 25, 2015 0

Excel VBA Introduction Part 15 – Do Until and Do While Loops DESCRIPTION Do Loops in VBA allow you to carry out a set of instructions repeatedly until some kind of condition is met. This […]

Excel Is Fun

Excel Magic Trick 1154

August 24, 2015 0

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

Excel Is Fun

Excel Magic Trick 1153

August 20, 2015 0

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

Dueling Excel

Dueling Excel 037

August 19, 2015 0

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

Excel VBA

Excel VBA Select Case Statements

August 18, 2015 0

Excel VBA Introduction Part 14 – Select Case Statements DESCRIPTION Select Case statements in VBA are similar to If statements in that they allow to test whether conditions are met and perform different actions based […]