## Find the smallest value in a list but bigger than a number

*Article updated on September 22, 2017*

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

**Answer:**

- MINIFS function [Excel 2016]
- MIN + IF functions [Excel 2013 and previous versions]

### MINIFS function [Excel 2016]

**Formula in cell C3:**

=MINIFS(D4:D11,D4:D11,">10")

### MIN + IF functions [Array Formula]

**Array formula in cell C12:**

=MIN(IF(A1:A25>10,A1:A25))

### Explaining array formula

A1:A25 is the list of values, the same as an array.

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

MIN(IF(A1:A25>10,A1:A25,"")) returns the smallest value in the array.

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

This post demonstrates how to find minimum and maximum value using two conditions. In this case they are date conditions […]

## Share this article