Support Board
Date/Time: Sat, 28 Dec 2024 07:26:07 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-10-19 15:03:13] |
| bekitz3 - Posts: 83 |
|
Thx tomgilb for the suggestions =IF(YourConditions,AA3,K4)
is this something I would enter into a "non auto-filling" cell such as K1, L1, etcThis 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:
can this techniques go in any cell? Also it seems I remember reading somewhere in another post that you mentioned INDEX/MATCH usage does not work well in New Spreadsheets....which I am using=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. ** Further elaboration on my previous example ** Let's say at the current bar I decide I need to use K20 & K10. I create a simple formula in K1: =K20-K10 When a new bar is added to the sheet, I now need K1 to be K21-K11. Etc, etc. |