MIN and MAX Between Two Dates For Each Region
See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with three criteria):
1. DMIN and DMAX functions and a Data Table
2. AGGREGATE Excel 2010 function
3. Examine Boolean multiplying for Max calculation.
4. Examine Boolean dividing for Min calculation.
5. MAX and MIN functions with 3 IF functions for 3 conditions