You can use the methods I listed here ot copy down the formulas, but only use it when arrayformula can’t work for your case.