New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how the AGGREGATE function can ignore errors.
Home
Microsoft Office How to Use the AGGREGATE function in Microsoft Excel 2010
By getexcellent
Jul 23, 2010 02:39 PM
You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.
Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.
Comments
Be the first, drop a comment!