MIN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/min-function/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 15:46:57 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png MIN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/min-function/ 32 32 Excel Formulas and Functions Everyone Needs to Know https://www.xelplus.com/excel-formulas-and-functions/ Thu, 11 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10316 Learn how to use Formulas and Functions in Excel. I'll show you an Excel trick that will make it easier to find Excel functions and use them correctly. You'll learn how to use SUM, COUNT, COUNTA, AVERAGE, MAX, MIN and also more complex functions like AVERAGEIFS.

The post Excel Formulas and Functions Everyone Needs to Know 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.

]]> 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) https://www.xelplus.com/excel-array-formula-unique-count-rows-excel-part1/ Thu, 19 Jan 2017 08:11:00 +0000 https://www.xelplus.com/?p=12721 Learn how to get the unique count across rows using an array formula based on the SUMPRODUCT and FREQUENCY functions.

The post 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) appeared first on Xelplus - Leila Gharani.

]]>