I have not found a solution yet, but I have found another inconsistency in
the processing of array formulas.

If you array enter

=MAX(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN(A1:D1 )))-MIN(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN(A1:D1) ))

in a 1x4 range of cells, you get the four columnwise max-min's, but

=COUNT(MAX(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN (A1:D1)))-MIN(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN(A1:D1) )))

only returns 1, and

=MAX(MAX(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN(A 1:D1)))-MIN(INDEX(IF(ISNUMBER(A1:D5),A1:D5),,COLUMN(A1:D1) )))

returns the first value, instead of the largest of the 4 values that were
returned by the original array formula.

Jerry

"T. Valko" wrote:

I can't come up with anything that ignores errors. I think this is a job for
Harlan!

If this can be done it's going to be a really expensive formula. You may be
better off using the helper row.

Biff

"Jerry W. Lewis" wrote in message
...
One more level of complexity: I need to ignore error values (#N/A's for
charting purposes) if present. The usual array approach of
IF(ISNUMBER(range),range) cannot be used with OFFSET.

Jerry

"T. Valko" wrote:

Hmmm.....

I wasn't sure what you meant but after seeing bj's replies..........

Range = A1:D5

Array entered:

=MAX(SUBTOTAL(4,OFFSET(A1:A5,,COLUMN(A1:D5)-1))-SUBTOTAL(5,OFFSET(A1:A5,,COLUMN(A1:D5)-1)))

Biff

"Jerry W. Lewis" wrote in message
...
I have an nxm rectangular range of cells, for which I want to determine
the
largest columnwise data span ("range" in statistical terms). Clearly,
I
can
do this using a row of m helper cells each containing
=MAX(column)-MIN(column)
with the desired result then given as =MAX(helper_row).

Can this be done in a single cell without the helper row?

Jerry