News

How to use Excel’s AGGREGATE Function. This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel. By Kelly L. Williams, CPA, Ph.D. April 1, 2025. ... (SUBTOTAL returns ...
If you see a spill error, then the range needed to fulfill the function isn’t available. What this means is that you can use one function to return multiple columns (or rows) of resulting values.