Excel Forum



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.