|
Featured Tutorial
Featured Macro
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
Link for file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm