Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1013-1016.xlsx

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to calculation MIN and MAX calculations with one condition. See how to calculate the minimum and maximum sale for each employee using:
1. DMIN function
2. DMAX function
3. MIN and IF array Formula that requires Ctrl + Shift + Enter
4. MAX and IF array Formula that requires Ctrl + Shift + Enter
5. MIN conditional calculation with AGGREGATE Excel 2010 function with division math array operation in array argument of AGGREGATE that does not require Ctrl + Shift + Enter
6. MAX conditional calculation with AGGREGATE Excel 2010 function with multiplication math array operation in array argument of AGGREGATE that does not require Ctrl + Shift + Enter