Support Board
Date/Time: Sun, 02 Feb 2025 14:46:27 +0000
Post From: Spreadsheet questions
| [2019-09-15 04:33:42] |
| Sawtooth - Posts: 4164 |
|
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. |