Support Board
Date/Time: Wed, 05 Feb 2025 15:57:24 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 02:46:08] |
| OneMoreTick - Posts: 79 |
|
Using a daily intraday chart to do a 3-day pivot, I tried using this formula in K3: =IF(AND(A3-INT(A3)>=$J$75,A4-INT(A4)<$J$75),K4+1,K4) But it just sets every K field to "1" all the way down. Date Time Of Last Edit: 2014-12-02 03:03:15
|