51:50Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)excelisfun32.0K viewsView & Download
7:34Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formulaexcelisfun13.1K viewsView & Download
8:37Excel Magic Trick 622: Array Formula to Return Even Row Data Onlyexcelisfun5.6K viewsView & Download
22:03Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALLexcelisfun34.9K viewsView & Download
3:46Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF)excelisfun5.1K viewsView & Download
17:44Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)excelisfun51.6K viewsView & Download
