mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have a file that is summing a YTD value by returning a range based on the month. The data for all 12 months exists in the same tab and an OFFSET function linked to the current month number eg 6 for June, sums and returns a range of 6 cells. This is currently performed on every single line of a P+L on many, many tabs.
I know OFFSET is volatile, what alternatives are there to perform the above less processor intensively.
thanks
I know OFFSET is volatile, what alternatives are there to perform the above less processor intensively.
thanks