![]() We can tell the AGGREGATE function to ignore the error, enabling it to calculate the correct result. We would typically turn to the LARGE function for this type of calculation, but in this circumstance, LARGE will return an error. Let’s say you want to find the 2nd largest result over a range of cells where those cells contain an #N/A error. ![]() To help you see the power, let’s consider some scenarios. But it’s better than those functions because it performs all of those whilst ignoring errors, hidden cells and other cells containing AGGREGATE and SUBTOTAL functions. That sounds the same as SUM doesn’t it? Hence the problem with its name, the AGGREGATE function does so much more than SUM.ĪGGREGATE can COUNT, AVERAGE, MAX, SMALL and SUM, to name just a few. What does the word aggregate mean? To form a whole from separate parts. My aim with this post is to show you how good AGGREGATE is, so that you can make use of its power. It is one of the most powerful functions in Excel, yet I’ve rarely seen it used in a real-life scenario. In Excel 2010, Microsoft introduced a new function called AGGREGATE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |