Array formulas are generally slower than non-array formulas. No way round that if you have to use them, but we can't really assist you if we have no idea what the formulas are.