Excel Is Fun

Excel Magic Trick 1163

September 24, 2015 0

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine […]

Excel Is Fun

Excel Magic Trick 1152

August 17, 2015 0

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

Dueling Excel

Dueling Excel 029

June 24, 2015 0

Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP […]

Excel Is Fun

Excel Magic Trick 1133

June 11, 2015 0

Aging Accounts Receivable Reports: PivotTable & Unique Identifier DESCRIPTION See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records: (01:49) Days Late Helper Column Formula: […]

Excel Is Fun

Excel Magic Trick 1132

June 8, 2015 0

Extract and Sort Numbers Greater Than Zero with Formula DESCRIPTION See how to Extract and Sort Numbers Greater Than Zero With Formula using COUNTIF, LARGE, and IF functions. WORKBOOKS

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 04

April 4, 2015 0

DESCRIPTION See two examples of Array Formulas and two examples of PowerPivot DAX formulas that count unique values in a column (Distinct Count) and compare and contrast: (00:09) Array Formula For counting unique values using […]

Dueling Excel

Dueling Excel 017

March 17, 2015 0

DESCRIPTION See Mr Excel and excelisfun Create 5 formulas to count times greater than five minutes. Excel functions COUNTIF and TIME. Different syntaxes for the criteria argument in the COUNTIF function WORKBOOKS

Dueling Excel

Dueling Excel 015

February 26, 2015 0

DESCRIPTION See Mr Excel use a Pivot Table with Grouping and a Count function to create a Frequency Distribution. See excel is fun use the FREQUENCY function (upper limit is included in count) to create […]

Dueling Excel

Dueling Excel 013

February 24, 2015 0

DESCRIPTION See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new […]