using INDIRECT in array formulas
This really is a piggyback to an earlier post, but does anyone know
why the following array formula generates #VALUE! errors?
{=INDIRECT(ADDRESS(ROW(),COLUMN()-2))}
This construction works for a single cell, but I need something like
it on a range of rows.
Steven Stovall
|