Thu, 16 December 2010
Excel 2010 now contains 400 Functions. Amongst those new Functions is a new Function called ‘AGGREGATE’. AGGREGATE is similar to SUBTOTAL, but with several new tricks, including MEDIAN, LARGE, SMALL, and the ability to ignore Error Values - which Bill will be looking at today, in Episode #1307. … This episode is the video podcast companion to the book, “Rev Up to Excel 2010: Upgraders Guide to Excel 2010” by Bill Jelen a.k.a. “MrExcel. For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions. |
Bill Jelen

