View Detailed Profile
Excel Magic Trick #181: Count Words Case Sensitive

Excel Magic Trick #181: Count Words Case Sensitive

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 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country

Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country

Download Files: Start File: https://excelisfun.net/files/EMT1387Start.xlsx Finish File: ...

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 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...

Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2...

Download

Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria

Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria

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 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF

Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF

Download

Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently

Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently

Excel Magic Trick

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

Download Excel Start File: https://excelisfun.net/files/EMT1178.xlsx

Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups

Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups

Download File: https://excelisfun.net/files/EMT1444-1445.xlsx See how to use

Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range

Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range

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