Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hello Smartsheet Community,
The formula I used in Microsoft Excel needed to be entered as an array.
What is the best way/formula to find the minimum value in a range that is not zero?
I don't know of a way to do this in a single formula but here's one way that I can see to do it. First create a new column and in each row of the area that you want to find the >0 minimum for, enter the formula: =IF(Ref>0,Ref,"") where Ref is the entry in the same row that participates in the search for the non-zero minimum. If the row in interest is zero or negative the formula rill return a blank. Then, at the bottom of the new column enter =MIN(Ref1:Ref2). The minimum non-zero value will be found.
You might also be able to do this with a report since you can control what the report looks for in the row in question by looking for numbers >0 in the rows and sorting by values.
