Excel Forum



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





Got a Question? Ask it Here in the Forum.