google sheets - MIN value excluding values lower then a value in another cell - Stack Overflow

So, I have something like this in the table. I need MIN value from Column A, but exclude values lower then B1 cell. So 5, 13, 14 are lower then 16, and result of the formula should be 34, the lowest value of the remaining values

Row	A	B
1	5	16
2	13
3	76
4	34
5	14
6	104

So, I have something like this in the table. I need MIN value from Column A, but exclude values lower then B1 cell. So 5, 13, 14 are lower then 16, and result of the formula should be 34, the lowest value of the remaining values

Row	A	B
1	5	16
2	13
3	76
4	34
5	14
6	104

• google-sheets
• google-sheets-formula

Share Improve this question Follow asked Jan 11 at 13:20 smooth operatorsmooth operator 7111 gold badge11 silver badge88 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 2

You may try:

=minifs(A:A,A:A,">"&B1)

Try this as an alternative

This formula is preferred to use with conditional logic

=ARRAYFORMULA(SMALL(IF(A:A > B1, A:A), 1))

Expected Result

A	B	C
5	16	34
13
76
34
14
104

Reference

• IF
• SMALL