Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore errors in range
The function =MAX(A:A) is giving a #N/A error because some of the cells in
column A are errors. Is there a way to tell MAX to ignore errors (perhaps by putting A:A into some sort of filter function)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore errors in range
=MAX(IF(NOT(ISERROR(A1:A100)),A1:A100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. You also cannot use whole columns in array formulae, it must be explicit. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "hmm" wrote in message ... The function =MAX(A:A) is giving a #N/A error because some of the cells in column A are errors. Is there a way to tell MAX to ignore errors (perhaps by putting A:A into some sort of filter function)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore errors in range
On Jun 14, 8:51 am, hmm wrote:
The function =MAX(A:A) is giving a #N/A error because some of the cells in column A are errors. Is there a way to tell MAX to ignore errors (perhaps by putting A:A into some sort of filter function)? You could also use this formula: =MAX( IF( ISERROR(A1:A100), "", A1:A100 ) ) which doesn't use the NOT function Again it must be entered as an Array formula Ctrl+Shift+Enter |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore errors in range
Hi
Or implement an error handling into your formulas in column A, like =IF(ISERROR(YourFormula,"",YourFormula) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "hmm" wrote in message ... The function =MAX(A:A) is giving a #N/A error because some of the cells in column A are errors. Is there a way to tell MAX to ignore errors (perhaps by putting A:A into some sort of filter function)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
Ignore errors when calculation average of multiple ranges | Excel Worksheet Functions | |||
How do I ignore cells with errors when calculating an average? | Excel Worksheet Functions | |||
vlookup, but ignore errors if #n/a | Excel Worksheet Functions | |||
Countif to ignore any errors | Excel Worksheet Functions |