Tag Archive: Excel Formula Tricks

Feb 05

Finding Upper Bound and Lower Bound Range from DataSet

Excel Advanced Formula Tricks #2:  How to find the Upper Bound Range and Lower Bound Range from the given data set? Solution:            We can achieve this by using Match Function in Excel. There is no direct way to do this in Excel.  Please watch the video below to achieve this …

Continue reading »




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.