The Excel #MAXIFS and #MINIFS functions return the largest or smallest value that meets one or more criteria in a range of values. Both functions are introduced in Excel 2019, but how you can get the maximum or minimum value based on criteria in the older version of excel? to do that you can use array formulas with the MAX or MIN function. In this video, I have explained in detail to get the condition based maximum or minimum value from a range of values.
Learn how to use the MINIFS & MAXIFS functions to find the Minimum and Maximum values in a column based on one or more conditions or criteria in excel 2016 or older version or in Excel 365 or Excel 2021.
-------------------------------------------------------------------------------------------------------------
Subscribe to RU-vid & Follow on Facebook Page👇
/ exceluniverse
/ exceluniverse.in
Excel MAX and MIN Functions👇
• MAX and MIN Function i...
How to use Nested IF in Excel👇
• Nested IF in Excel
All About Average-Basic👇
• Statistical Function :...
Extract Unique List in Excel 2016👇
• How to Extract Unique ...
Index Function :- Array & Reference👇
• How to use Index Funct...
All About MATCH Function👇
• Match Function in Excel
VLOOKUP with MATCH Function👇
• VLOOKUP with MATCH Fun...
3D LOOKUP 👇
• Excel 3D Formulas - Mo...
Download File from Link Below👇
mega.nz/file/I...
14 окт 2024