Effective method to paste array formula
Ordinarily, if an array formula has already been successfully entered
in a cell, all you have to do is copy it. The "array" character of the
formula will persist. From what I see here, the $$ are all OK, suitable
for a 2-D calculation. So, all you have to do is:
Select single cell with array formula
Copy
Select all destination cells
Paste
(or use the autofill handle to copy)
HTH
Kostis Vezerides
|