Normally, I would just enter in an array such as: MIN(IF(A1:G1>0, A1:G1, FALSE))

The only problem is, my numbers are not contiguous (i.e. their positions are A1, G1, P1, etc.). Does anyone know a formula that will return the minimum, positive number from a set of non-contiguous numbers?

**extra gratitude to anyone who can do this without an array, as the arrays would make my file size quite large.**

Thanks!