Conditional MIN() & MAX()

We can get the conditional Minimum and Maximum values using as array function.

function used as follows

Press CTRL+Shift+Enter ..... to get result or convert the formula as array function.