View Detailed Profile
Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

Download

Excel Magic Trick 290: Count Codes From Column of Text Strings

Excel Magic Trick 290: Count Codes From Column of Text Strings

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 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 1093: Extract Date from Middle of Description: Text To Columns or Formula?

Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula?

Download

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods

Download

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

Excel Magic Trick #198: 3 Formulas For Frequency Distribution

Download

Excel Magic Trick #181: Count Words Case Sensitive

Excel Magic Trick #181: Count Words Case Sensitive

Download

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart

Download Files: Start File: https://excelisfun.net/files/EMT1396-97.xlsx https://excelisfun.net/files/EMT1397%20Part%2002.xlsx ...

Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula

Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula

Other Related Videos: Mr Excel Excel Challenge back in 2007 http://www.mrexcel.com/pc17.shtml

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 1120: Is Item in All Three Lists?

Excel Magic Trick 1120: Is Item in All Three Lists?

Download

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download