dekike, November 22, 2022 - 9:58 am UTC
Excel OFFSET is an excellent formula for performing dynamic calculations with "moving" ranges. It's slow because it has to find the top offset rows and then scan the next 100 rows. When you're dealing with massive amounts of data, no amount of optimization will change that.
November 22, 2022 - 1:28 pm UTC