Array formula that works columnwise?
I think that you would need a macro function to do it in one cell.
"Jerry W. Lewis" wrote:
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
|