From: msao on 17 Nov 2009 14:58 Need to take a colum and find the smallest number in it but it must be greater than 0.01 any help would be great From: Mike H on 17 Nov 2009 15:30 Hi, Try this ARRAY formula =MIN(IF(A1:A20>0.01,A1:A20)) This is an array formula which must be entered by pressing CTRL+Shift+Enter 'and not just Enter. If you do it correctly then Excel will put curly brackets 'around the formula {}. You can't type these yourself. If you edit the formula 'you must enter it again with CTRL+Shift+Enter. Mike "msao" wrote: > Need to take a colum and find the smallest number in it but it must be > greater than 0.01 any help would be great > From: msao on 17 Nov 2009 15:51 still will return 0.00 as the lowest number "Mike H" wrote: > Hi, > > Try this ARRAY formula > > =MIN(IF(A1:A20>0.01,A1:A20)) > > This is an array formula which must be entered by pressing CTRL+Shift+Enter > 'and not just Enter. If you do it correctly then Excel will put curly brackets > 'around the formula {}. You can't type these yourself. If you edit the formula > 'you must enter it again with CTRL+Shift+Enter. > > Mike > > > > "msao" wrote: > > > Need to take a colum and find the smallest number in it but it must be > > greater than 0.01 any help would be great > > From: Glenn on 17 Nov 2009 16:28 It returned 0.00, or you think it will so you didn't try it? msao wrote:> still will return 0.00 as the lowest number > > "Mike H" wrote: > >> Hi, >> >> Try this ARRAY formula >> >> =MIN(IF(A1:A20>0.01,A1:A20)) >> >> This is an array formula which must be entered by pressing CTRL+Shift+Enter >> 'and not just Enter. If you do it correctly then Excel will put curly brackets >> 'around the formula {}. You can't type these yourself. If you edit the formula >> 'you must enter it again with CTRL+Shift+Enter. >> >> Mike >> >> >> >> "msao" wrote: >> >>> Need to take a colum and find the smallest number in it but it must be >>> greater than 0.01 any help would be great >>> From: Gord Dibben on 17 Nov 2009 16:47 Not in my testing. Returns 0.010000001 as minimum but not 0.01 or less. How are your cells formatted? Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:51:01 -0800, msao wrote: >still will return 0.00 as the lowest number > >"Mike H" wrote: > >> Hi, >> >> Try this ARRAY formula >> >> =MIN(IF(A1:A20>0.01,A1:A20)) >> >> This is an array formula which must be entered by pressing CTRL+Shift+Enter >> 'and not just Enter. If you do it correctly then Excel will put curly brackets >> 'around the formula {}. You can't type these yourself. If you edit the formula >> 'you must enter it again with CTRL+Shift+Enter. >> >> Mike >> >> >> >> "msao" wrote: >> >> > Need to take a colum and find the smallest number in it but it must be >> > greater than 0.01 any help would be great >> >  |  Next  |  Last Pages: 1 2 Prev: Range with 2 validationsNext: conditional Formatting cell wildcard