| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring blanks from Column(s) | Excel Worksheet Functions | |||
| Ignoring negative number | Excel Worksheet Functions | |||
| Adding a certain number until minimum is reached | Excel Discussion (Misc queries) | |||
| calculating the minimum value ignoring o | Excel Worksheet Functions | |||
| How do I sum a number of columns and ignore the minimum value? | Excel Discussion (Misc queries) | |||
Hybrid Mode
