How to get the minimum number of one column while ignoring the err
 

Since the column that I reffered to contains some errors (#N/A), I will also
get a #N/A if I use the formula min to get the smallest value of that column.
Could you please tell me how to get the result I want? Thank you.

How to get the minimum number of one column while ignoring the err
 

=MIN(IF(ISNUMBER(A1:A500),A1:A500))

ctrl+shift+enter, not just enter


"Yuanhang" wrote:

Since the column that I reffered to contains some errors (#N/A), I will also
get a #N/A if I use the formula min to get the smallest value of that column.
Could you please tell me how to get the result I want? Thank you.

How to get the minimum number of one column while ignoring the err
 

One way ..

Assuming range is A1:A10,
put in say, B1, then array-enter the formula by pressing CTRL+SHIFT+ENTER,
instead of just pressing ENTER:
=MIN(IF(ISNUMBER(A1:A10),A1:A10))

Adapt the range to suit. Entire col references (eg: A:A) cannot be used.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


"Yuanhang" wrote:

Since the column that I reffered to contains some errors (#N/A), I will also
get a #N/A if I use the formula min to get the smallest value of that column.
Could you please tell me how to get the result I want? Thank you.