Support Board
Date/Time: Sat, 28 Dec 2024 07:17:25 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-10-16 21:00:02] |
| Sawtooth - Posts: 4143 |
|
A persistent variable can be created in a spreadsheet array by using something like this: =IF(YourConditions,AA3,K4) This will bring your example K10's value to K3 to be able to be used in real time, assuming you condition hasn't changed in between. If your conditions change in between, another way to grab a value in 'K10' is to use another formula column, e.g. column P, with this: =IF(YourConditions,1,0) Then use something like this in yet another formula column: =INDEX(K3:K1002,MATCH(1,P3:P1002,0),1) This will grab the value in column K where the most recent '1' occurred in column P. |