Photo Gallery

Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functions
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes
Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row
Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift
Excel Magic Trick #127: Count Less Than 70% of Max
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula