«

»

Dec 13

Excel Advanced Formula Tricks: Min ignore Zero for non-contiguous range

Sub: Min ignore Zero for non-contiguous range

 

Issue:

        How to ignore zero in the min formula for a non-contiguous range ?

Solution:

 

If the above solution is useful please leave your comment below. 

 

About the author

Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">