Excel Is Fun

Excel Magic Trick 1197

March 21, 2016 0

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, […]

Excel Is Fun

Excel Magic Trick 1196

March 14, 2016 0

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

Dueling Excel

Dueling Excel 68

March 9, 2016 0

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

Excel Is Fun

Excel Magic Trick 1193

February 22, 2016 0

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

Excel Is Fun

Excel Magic Trick 1182

December 7, 2015 0

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

Excel Is Fun

Excel Magic Trick 1181

November 30, 2015 0

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

Excel Is Fun

Excel Magic Trick 1178

November 16, 2015 0

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

Excel Is Fun

Excel Magic Trick 1172

October 26, 2015 0

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

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