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?


          We can achieve this by using Match Function in Excel. There is no direct way to do this in Excel. 

Find_the_Upper_Bound_and_LowerBound Range

Please watch the video below to achieve this in a simple way. 

NB: Videos are the only way to get better understanding rather than reading for a long time

Please leave your comments below if this tip is useful. 



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="">