Main Profile

At A Glance

Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods

Extract Month Year Records From Transactional Data using: 1. Filter 2. Array Formula using IF, ROW, SUMPRODUCT, TEXT, INDEX, SMALL functions 3. 2010 non-array formula using AGGREGATE function & IF, ROW, SUMPRODUCT, TEXT, INDEX, functions Extract Records with Formula Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm
Length: 10:34

Contact

Questions about Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods

Want more info about Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question