View Detailed Profile
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Download

Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)

Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)

Download

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Download

Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group

Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group

Download

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Download

Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format

Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format

Download

Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?

Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?

Download

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Download

Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula

Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT597-603.xls See how to Use Boolean Math and the ...

Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

Download

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Download

Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row

Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row

Download

Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems

Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems

Download