yogi_Compute MIN And MAX Values From A Range Of Computed Results Using ArrayFormula (with no results available for a range of cells)

                                          Google Spreadsheet   Post  #1352
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 01, 2013
user Nicolas Asselin (http://productforums.google.com/forum/?zx=z16a51nugtxq#!mydiscussions/docs/fB7OwzOgMGE)
how to ignore cell with no value in a formula
hi,

i have some historical data for stock like price, etc. and i want to know the lower price in the data. i tried using the formula =min(K2:K482) but i have some empty cell in this column so the function doesnt work. is there a way to ignore empty cell in the min and max function? thanks a lot

---

Hi, thanks for the quick response

https://docs.google.com/spreadsheet/ccc?key=0AgJnK4wAlaQudGZRemhESEpNeVdrakZObDc3aFJKRnc&usp=sharing

no i dont get any value at all... see I4 ans I6

thanks

--------------------------------------------------------------------------------------------------------