Excel Is Fun

Excel Magic Trick 1166

October 5, 2015 0

Count Dates From Date-Time Values: COUNTIFS or PivotTable? DESCRIPTION See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable: (00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula (00:45) COUNTIFS […]

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

July 27, 2015 0

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check […]

Dueling Excel

Dueling Excel 027

June 10, 2015 0

COUNT w More Than 1 Criteria 10 Examples! DESCRIPTION See Mr Excel and excelisfun use 10 different methods for counting with more than 1 criteria. See the functions: SUMPRODUCT w multiplying, SUMPRODUCT w double negative, […]

Excel Is Fun

Excel Magic Trick 1128

April 28, 2015 0

DESCRIPTION See how to create an automated Accounting Ageing Accounts Receivable Reports On Multiple Sheets With Array Formula, Excel Table Feature and Formula Table Nomenclature (Structured References): (00:16) Overview of end result: Automatic Ageing Reports […]

Excel Is Fun

Excel Magic Trick 1118

April 18, 2015 0

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract […]

Dueling Excel

Dueling Excel 020

March 20, 2015 0

DESCRIPTION See Mr Excel and excel is fun summarise survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting […]

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