Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Easily Input Complex Functions in Excel
Tutorial: In this tutorial I am going to show you how to easily input complex Functions in Excel. To...
How to Find and Fix Errors in Complex Formulas in Excel
Tutorial: Here, I'll show you a quick, simple, and effective way to fix formulas and functions in E...



Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula


See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.

Link for file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.