A1:A5000 Vs A:A

[Russk68]

I have always put a limit on column ranges in formulas thinking that it will be quicker to calculate. I have also ran into problems when I would expand data on a sheet where other sheets become inaccurate because I did not update the formula. So, does a formula like Index Match with A1:A5000 calculate faster vs A:A?

 

[Fluff]

By & large, yes it will take longer, especially if you are using array formulae.

 

[RoryA]

Most functions (as opposed to operators like * or +) will only calculate based on the used range of the references, so I doubt you will see much difference generally. You could also use tables or dynamic named ranges.

 

[Russk68]

Most functions (as opposed to operators like * or +) will only calculate based on the used range of the references, so I doubt you will see much difference generally. You could also use tables or dynamic named ranges.

Thank you!