Excel Is Fun

Excel Magic Trick 1157

September 3, 2015 0

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

Dueling Excel

Dueling Excel 039

September 2, 2015 0

Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT DESCRIPTION See Mr Excel and excelisfun lookup a row of data using VLOOKUP & OFFSET wrapped in a SUMPRODUCT function to calculate a Difficulty […]

Excel VBA

Excel VBA Find and FindNext

September 1, 2015 0

Excel VBA Introduction Part 15a – Find and FindNext DESCRIPTION You can use the Find and FindNext methods in Excel VBA to find values in a worksheet – exactly as the name suggests! This video […]

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