Excel Is Fun

Excel Magic Trick 1196

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then [Read More >>>]

Dueling Excel

Dueling Excel 68

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS [Read More >>>]

Dueling Excel

Dueling Excel 020

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 [Read More >>>]

Dueling Excel

Dueling Excel 015

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1193

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup [Read More >>>]

Excel Is Fun

Excel Magic Trick 1182

COUNTIFS and Wildcards to Count When There are 4 or More Characters DESCRIPTION See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz [Read More >>>]

Excel Is Fun

Excel Magic Trick 1181

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT DESCRIPTION See how to: (00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double [Read More >>>]

Excel Is Fun

Excel Magic Trick 1178

Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? DESCRIPTION From Survey Results, see examples of how to calculate the percentage of No responses given that the response was from a Full Time Faculty in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1172

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT DESCRIPTION See how to: (00:38) INDEX and MATCH functions to lookup a column (00:50) Highlight non-contiguous ranges using Ctrl (03:13) Enter Formula into non-contiguous ranges using [Read More >>>]