Excel: Find the smallest value in a list but bigger than 10.
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
Related posts:
Excel: Find the smallest difference between the two closest values
List five smallest numbers, excluding zeros
Return row reference of largest to smallest
Highlight smallest duplicate value in a column using conditional formatting in excel
Excel: Count the number of occurances an integer is in a list
Recommended categories
