Will this be useful? Let me know what you think. 👀Have you watched this video on Table Traps including how to lock references? ua-cam.com/video/vbBXa3DcgyI/v-deo.html Also, check out the great tip from @operlandsen in the comments.
You can define the name to refer to this formula: =!A1 (assuming the active cell is in Sheet1 cell A2). Then you can keep the Workbook level scope for the name and it will work in all worksheets.
Nice! Do you have any video that explains when offset slows down your file a lot? You mention depending on where you use it in the formula, but I don't know how to interpretate this. Nice hashtag as well 😁
Thanks 😀. Offset recalculates every time a change is made to any cell in your file. So if the offset is in a cell that has a long chain of subsequent dependent values then that’s a lot of calculations being triggered each time. If the offset has no dependent formulas the impact would be very small.
Will this be useful? Let me know what you think.
👀Have you watched this video on Table Traps including how to lock references?
ua-cam.com/video/vbBXa3DcgyI/v-deo.html
Also, check out the great tip from @operlandsen in the comments.
Interesting method. Thank you, Wyn!!!
No worries
Neat! Running totals can be a bit of a nightmare so this is a really useful solution.
Cheers Shirley
You can define the name to refer to this formula: =!A1 (assuming the active cell is in Sheet1 cell A2). Then you can keep the Workbook level scope for the name and it will work in all worksheets.
Great tip !
@operlandsen. Oddly conditional formatting wont accept a name with an =!A1 style
Great technique and use of named formula wish I had known years ago.
Hope it helps in future!
Nice! Do you have any video that explains when offset slows down your file a lot? You mention depending on where you use it in the formula, but I don't know how to interpretate this. Nice hashtag as well 😁
Thanks 😀.
Offset recalculates every time a change is made to any cell in your file. So if the offset is in a cell that has a long chain of subsequent dependent values then that’s a lot of calculations being triggered each time.
If the offset has no dependent formulas the impact would be very small.
Love it!
Cheers 😀
To avoid named range: =SUM(INDEX([Units],1):[@[Units]]). This is dynamic so any change in rows will not affect the results.
Nice
Great technique and yes, will be very useful! :-)
Best wishes for 2025!
Cheers Geert