Minimum value from cells

[hsandeep]

I have non-contiguous row cells X40; X48; X53; X58; X62; X66. I need an Excel formula such that it gets the minimum value of X40; X48; X53; X58; X62; X66 which should be non-zero and non-blank.

How to accomplish?
Thanks in advance

 

[etaf]

how about
=SMALL((X40, X48, X53, X58, X62, X66),INDEX(FREQUENCY((X40, X48, X53, X58, X62, X66),0),1)+1)

Book2
	X
35
36	0.5
37
38	X40, X48, X53, X58, X62, X66
39
40	1
41
42
43
44
45
46
47
48	0
49
50
51
52
53
54
55
56
57
58
59
60
61
62	0.5
Sheet1

Cell Formulas
Range	Formula
X36	X36	=SMALL((X40, X48, X53, X58, X62, X66),INDEX(FREQUENCY((X40, X48, X53, X58, X62, X66),0),1)+1)

 

[hsandeep]

=SMALL((X40, X48, X53, X58, X62, X66),INDEX(FREQUENCY((X40, X48, X53, X58, X62, X66),0),1)+1)

Thats it..Thanks etaf

 

[etaf]

you are welcome

 

[hsandeep]

Thats it..Thanks etaf

etaf, Would you like to explain why did you added 1 in the formula?