Support Board
Date/Time: Tue, 04 Nov 2025 11:41:10 +0000
Post From: Overlaying Pivot Points
| [2021-08-12 10:47:39] |
| Botan626 - Posts: 294 |
|
Strangely, I don't see it anymore. When I saw it the last time, I pressed 'Recalculate All Formulas' button and it was gone. I have a Q about formula in L3 from post #21: =MAX(K3:OFFSET(K3,$J$30-2,0)) Why is it $J$30-2
?Doesn't K3 count as 1 cell with row 3, so we need to give it 997 offset to get the last value in the column, if J30=1000? Date Time Of Last Edit: 2021-08-12 11:02:42
|