Content Analysis: Download Files: Entire page with all

Photo Gallery

Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array
Excel Magic Trick 1169: Are Items In Row In Master List? Filter & Conditionally Format To Highlight
Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)
Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?
Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010
Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula
Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test