I am calculating a minimum value, but I don't want the data to include zeros.
Hi,
I want to calculate the minimum value but exclude all zeros.
I tried previously suggested solutions, but it is still not working. Any ideas?
Best Answer
Comments

The minimum summary method does not work for me because it brings back zeros, which makes sense. I want the calculation to take into consideration the minimum of the highlighted nonzero numbers only. I tried IF statements, but since it ends with Else 0, I am still getting zeros.
0 
I think you can use optimizer for this. Excluding zeros and getting minimum value.
Thanks,
Manjunath
0 
Thank you so much for your timely solutions @Misbah, @ManjunathKN , and @ShubhamCh . The only issue is getting rid of the infinity, but this is good for now.
0 
@ManjunathKN , can you expand on that? Any pictures or examples you can share?
0 
@ymugeni if above solution helps then very well. You may go through the optimizer lesson, they have explained there.
Thanks,
Manjunath
0 
In the screenshot shared by me, I have added 2 independent line items as a different solution. You can also use that solution. It won't show "Infinity" in the cells. The second line item  solution2 L2 is optional. You want to use it, use it otherwise use solution2 L1's summary (Min).
 Shubham
0 
Ok, will do. Thanks.
0