Formula Processing

Hi Gareth

Thanks for getting in touch.

I'm not aware of a 'league table' of formula processing time. You are right; some do take longer than others. Some of them are call other functions in the background so on a lot of data can see a significant delay.

Two ways to increase the speed of formula execution include: converting to an array (or CSE) formula often sees dramatic improvement, or using VBA to access the data directly without having to use the Excel interface. If you are experiencing noticeable slowdown executing formulas, a custom VBA routine or function is probably the way to go.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector