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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top