Support Board
Date/Time: Thu, 18 Dec 2025 22:47:08 +0000
Post From: Spreadsheet questions
| [2019-09-15 04:33:42] |
| Sawtooth - Posts: 4300 |
|
This will return the Volume 8 bars ago: =OFFSET(F3,8,0) If you want to return the value at the most recent event some unknown bars ago, e.g. in P3: =IF(Event,O3,P4) The most recent event could be in any column at any row, and the value in column O at that row is made persistent until another event, or to the current row (Row 3). There are also other ways to return values at previous events. |