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.
Returns the smallest value in a set of values, ignores logical values and text