PDA

View Full Version : Solved: Min of 4 Nos,returning >0 values



nitzbar
08-14-2008, 11:51 AM
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
08-14-2008, 01:04 PM
Haven't we already done this one to death?

nitzbar
08-14-2008, 01:08 PM
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
08-14-2008, 02:51 PM
=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)))))