Loading...

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

6,055 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Aug 6, 2010

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/mgirvi...

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...