| 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. |
| 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) | |||
Threaded Mode
