Maximum if multiple criteria |
IF MIN |
Maximum value |
|
Maximum value if |
IF |
Minimum if multiple criteria |
IF MIN |
Minimum value |
MIN |
Minimum value if |
IF MIN |
nth largest value |
LARGE |
nth largest value with criteria |
LARGE |
nth smallest value |
SMALL |
nth smallest value with criteria |
SMALL |