Array formula that works columnwise?
Very slick!
Thanks,
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
|