Sunday, September 1, 2013

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   Sep 01, 2013
user Nicolas Asselin (!mydiscussions/docs/fB7OwzOgMGE)
how to ignore cell with no value in a formula
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
no i dont get any value at all... see I4 ans I6