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(F
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
Last Comment
Ian Bell
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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
ASKER
This is the formula you provided.
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
ASKER
Sorry for the delay replying. The formula works well
Thank You guys
Ian
Thank You guys
Ian
any suggestions ??
Ian