View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default 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