Content Analysis: Download Files: See how to use the

Photo Gallery

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…
Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula
Excel Magic Trick 462:Show Formula Formula - Excel 4 Macro Function GET.CELL
Excel Magic Trick #198: 3 Formulas For Frequency Distribution
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)
Excel Magic Trick 472: Count Spaces at Beginning & End of Text String Simple Formula
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL