Excel Magic Trick 1284


History of Excel Max or Min with Conditions / Criteria (5 Examples)

DESCRIPTION

Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that have been used throughout Excel History:
(00:12) Introduction
(00:47) DMIN and DMAX functions
(03:40) MIN & IF function with Array Operations, and the MAX & IF function with Array Operations
(07:43) New in Excel 2010: AGGREGATE function with Array Operations
(10:41) New in Excel 2016: MAXIFS and MINIFS functions
(11:55) PivotTable with Filter on Row Area and Filter Area and MIN and MAX Functions
(13:27) Historical Summary

WORKBOOKS

Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 774 times – 4 MB




Be the first to comment

Leave a Reply