Problem: Find the smallest value in a list but it has to be bigger than 10.

Solution:Type =MIN(IF(A1:A25>10,A1:A25)) in a cell and press Ctrl + Shift + Return. Ctrl + Shift + Return makes it a matrix formula.

A1:A25 is the list of values, the same as a matrix or array.

IF(A1:A25>10,A1:A25) sorts out all values in the matrix above 10.

MIN(...) finds the the smallest value.

If the Ctrl + Shift + Return is left out only the first value in the matrix is executed in the formula.

MIN(number1;[number2];...)
Returns the smallest value in a set of values, ignores logical values and text