Solved: Min of 4 Nos,returning >0 values

[nitzbar]

Hi ! I have a spreadsheet with numbers in 4 columns e,h,j &l. I need to write a function that will return the minimum of these numbers in say column N while ignoring blank values, symbols and zeros and returning a positive number. Please help me out.

[Bob Phillips]

Haven't we already done this one to death?

[nitzbar]

i know.. i'm sorry about this..... but this this time the columns aren't evenly spaced out... wasnt sure on how i could modify the previous formula to work for this... i'm dealing witha lot of data, so formatting it becomes a bit cumbersome....

[Bob Phillips]

=MIN(IF(ISNUMBER(N(OFFSET(E1,0,{0,3,5,7},1,1))),IF(N(OFFSET(E1,0,{0,3,5,7}, 1,1))>0,N(OFFSET(E1,0,{0,3,5,7},1,1)))))