Copying Array Formulas

[dhstein]

Is there any way to copy an array formula across and down in a range? Or do
you have to "CTRL = Shift + Enter" each one ? Thanks for any help on this.

 

[Don Guillett]

Just drag. Make sure you have absolutes where you want them $a$1:$a$100