Hi,

I have values in column A and would like to create a formula in B1 that will find the smallest value in A and then count down the column the number of cells until a zero is reached.

E.g. if the smallest value is in A102 and then next zero is in A112, the formula should return 10.

Could someone please suggest a solution.

Thanks!