Q Qiqi New Member Sep 16, 2009 #1 How do you determine the upper or lower limit of a range, for eg. if the range is from 10,000- 20,000, what would be the upper limit?
How do you determine the upper or lower limit of a range, for eg. if the range is from 10,000- 20,000, what would be the upper limit?
K keymaster New Member Sep 16, 2009 #2 you mean like the row number of first cell and last cell ? or statistical upper and lower limit ?
K keymaster New Member Sep 16, 2009 #4 Max and Min ofcourse. here is the help: http://chandoo.org/excel-formulas/max.html and http://chandoo.org/excel-formulas/min.html You can even try the percentile to find 5th and 95th percentile if you are in to that sort of thing...
Max and Min ofcourse. here is the help: http://chandoo.org/excel-formulas/max.html and http://chandoo.org/excel-formulas/min.html You can even try the percentile to find 5th and 95th percentile if you are in to that sort of thing...
