Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
286
Views
Topic starter
Hi
Having recently realised that the volatile Offset function may be contributing to slow performance I am keen to replace with an alterative.
I use Sum(Offset(...)), see attached, to work out the budget to date (from a 12 month phased budget).
I can use Index to return a single cell but struggling to find the same for a row range (ie month 1: month m) where m is the reporting month referenced by the formula.
Grateful for any help!
Casey
Posted : 27/04/2022 6:13 pm
Hi Casey,
When you use INDEX you need to use it on both sides of the range operator e.g.:
=INDEX(...) : INDEX(...)
Or if the starting cell is always fixed, then:
=A1 : INDEX(...)
More on using INDEX to return a dynamic range here.
Mynda
Posted : 27/04/2022 10:26 pm
