=SMALL(A2:F2,COUNTIF(A2:F2,"<=0")+1)
RocketDude wrote:
Hi and sorry for the cross-posting but I'm desperate,
Does anyone know how to find the minimum of a row of numbers, but only for
numbers greater than zero? I have over three hundred rows I need to perform
this same function on, so naming the row is out of the question.
For example, if my row is:
0 0 0 1 2 3 5 0 0.5
I want to find "0.5".
TIA
|