Support Board
Date/Time: Fri, 28 Feb 2025 17:16:33 +0000
Post From: Overlaying Pivot Points
| [2021-08-10 23:49:21] |
| Sawtooth - Posts: 4177 |
|
Now let's find the current day using these formulas: K3: =IF(INT(A3)>INT(A4),K4+1,K4) This finds the date change and increments the previous count starting at the first date in column A. (Column A contains the SerialDateTime where the integer is the number of days since Dec 30, 1899, and the decimal is the portion of each day.) Spreadsheet Functions: Serial DateTime Values L3: =MAX(K3:OFFSET(K3,$J$30-2,0)) This finds the max count of days in column A. J30 is the Number of Rows in the spreadsheet, which follows the setting of the same name. O3: =IF(L3=$K$3,ID3.SG12@3,0) This compares the max number of rows to the latest count of days, and if they are equal, it is the current day so show the line, else 0. Edit all of the formulas in O3 to U3 to include the IF portion, retaining each ID#.SG#. This will always automatically find the current day, and only display the pivots for that day. Spreadsheet Functions: Available Functions |