Support Board

Date/Time: Mon, 13 May 2024 03:24:34 +0000

Post From: Lock a One Time Value in a spreadsheet

[2014-02-02 16:26:25] Link To Thread - Link To Post [Go To First Post]
User025429 - Posts: 26
Thanks Tom. I am trying to retain either a bar number or the bar time, not both. I want to list all subsequent bars that come after the specified bar/time to perform calculations only on these bars. In your example, in the place of the 5000, I want to reference a cell to "get" the number and then not refresh that number after that. Is there a more efficient way of doing it?