Support Board
Date/Time: Fri, 22 Nov 2024 06:54:16 +0000
Post From: Spreadsheet Study Column J - Day Max
| [2024-11-06 04:20:06] |
| Sawtooth - Posts: 4118 |
|
I just need to change 2000 so instead it starts at 1800 and finishes at 16:59:59 daily.
Use a formula like this in row 3 of a spare Formula Column, e.g. column L:=IF(FRACTIME(A3)=TIME(18,0,0),ROW(),L4) this will return the row # of the 18:00:00 bar. Then use a formula like this in any spare cell, e.g. J1, or any cell in row 1, or any cell in column H: =MAX(K3:OFFSET(K3,L3-3,0)) this will find the max value from the current bar to the 18:00:00 bar. this will be accurate until the next 18:00:00 bar. Date Time Of Last Edit: 2024-11-06 13:59:02
|