AGGREGATE function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/aggregate-function/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 01:01:30 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png AGGREGATE function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/aggregate-function/ 32 32 Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]> How to Get Multiple Match Results in Excel Without the FILTER Function https://www.xelplus.com/excel-multiple-match-results-complete/ Thu, 28 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11320 If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your problem best.

The post How to Get Multiple Match Results in Excel Without the FILTER Function appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel MAXIFS & MINIFS Functions with Multiple Criteria https://www.xelplus.com/excel-maxifs-minifs-with-conditions/ Thu, 22 Aug 2019 09:00:00 +0000 https://www.xelplus.com/?p=12243 Is there an Excel MAX IF or MIN IF function? Yes. There is MAXIFS and MINIFS functions that allow you to get the MAX or MIN value based on criteria. IF you don't have these functions you have alternate ways of getting this done. One option is to use AGGREGATE function

The post How to Use Excel MAXIFS & MINIFS Functions with Multiple Criteria appeared first on Xelplus - Leila Gharani.

]]> Return Multiple Match Values in Excel https://www.xelplus.com/return-multiple-match-values-in-excel/ Thu, 30 Aug 2018 10:26:00 +0000 https://www.xelplus.com/?p=9715 What to do when VLOOKUP falls short? It can't return multiple match results. But there are formulas that can. Here, I show you 2 different methods that return multiple matches: a combination of INDEX & AGGREGATE, which are available in all Excel versions, and TEXTJOIN, which was first introduced in Excel 2016 and Office 365.

The post Return Multiple Match Values in Excel appeared first on Xelplus - Leila Gharani.

]]> Find Multiple Matches in Excel & Create a Dependent Drop Down List https://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/ Thu, 15 Mar 2018 10:38:00 +0000 https://www.xelplus.com/?p=11023 In this tutorial, we will create a dependent drop-down list based on a messy Excel Table. For that purpose, we will extract all records for each category using the combination of INDEX and AGGREGATE. Next, we will fix the column referencing in the table. Finally, we will use a combination of OFFSET and COUNTIF to get a drop-down list restricted to non-empty cells.

The post Find Multiple Matches in Excel & Create a Dependent Drop Down List appeared first on Xelplus - Leila Gharani.

]]> Excel Complex Lookup: Find Header https://www.xelplus.com/complex-lookup-index-sumproduct/ Tue, 05 Sep 2017 09:52:00 +0000 https://www.xelplus.com/?p=11968 In this tutorial we tackle a complex lookup problem - how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

The post Excel Complex Lookup: Find Header appeared first on Xelplus - Leila Gharani.

]]>