Content Analysis: Download Files: See three methods to

Photo Gallery

Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula
Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table
Excel Magic Trick # 3: AVERAGE & Go To Blanks
Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula
Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function
OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable
Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables