Excel Forum
Similar Content
Stop Formula Calculation in Excel - Increase Worksheet Performance
Tutorial: I'll show you how to stop formulas and functions from performing their calculations and u...
How to Use Multiple Functions and Formulas in a Single Cell in Excel
Tutorial: Lets learn how to put multiple functions and formulas in a single cell in Excel in order t...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...

Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria

See how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it does not require Ctrl = Shift + Enter. Use AGRREGATE to Replace SMALL function in array formula.
Array formulas: 1) For AGGREGATE function, Numbers come first, then divide, then criteria; 2) For IF function, Criteria come first, then comma, then numbers.
AGGREGATE function joins the ranks of LOOKUP, INDEX and SUMPRODUCT as functions that can handle arrays!
Download files: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.