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 |
>Solution :
You may try:
=minifs(A:A,A:A,">"&B1)