asked on # min amount formula exclude zero

Hi

I would like to modify the following formula to calculate the minimum value in a range of cells exclude zeros and

determine the max number of rows.

=SMALL((Q9:Q50000),INDEX(FREQUENCY((Q9:Q50000),0),1)+1)

I have set to a maximum of 50,000 rows

Thanks for your help

Ian

I would like to modify the following formula to calculate the minimum value in a range of cells exclude zeros and

determine the max number of rows.

=SMALL((Q9:Q50000),INDEX(F

I have set to a maximum of 50,000 rows

Thanks for your help

Ian

Microsoft Excel

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Hope you used =small((

2 brackets as I missed one earlier

2 brackets as I missed one earlier

This is the formula you provided.

It has 2 opening and two closing brackets

=SMALL(Q9:Q200000,COUNTIF(Q9:Q200000,0)+1)

If all the cell contents contain zero then it posts the #NUM error

It has 2 opening and two closing brackets

=SMALL(Q9:Q200000,COUNTIF(

If all the cell contents contain zero then it posts the #NUM error

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Could you precise this

and determine the max number of rows.

Sorry for the delay replying. The formula works well

Thank You guys

Ian

Thank You guys

Ian

any suggestions ??

Ian