You're welcome.
I hadn't thought about this before, but this is a general way to
clean up a sheet, by putting intermediate calculations on another sheet.
If one names the cells, the names turn out to be global, in the sense
that they are known to all sheets, ant the prefix "Sheet<n>." isn't
needed.
Cheers Dale
On Nov 11, 2008, at 2:08, Graham Smith wrote:
Robertson,
I think in this instance Brians single
array formula approach is the way to go.
Thanks for the help,
Graham
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
