still will return 0.00 as the lowest number

"Mike H" wrote:

Hi,

Try this ARRAY formula

=MIN(IF(A1:A200.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