Support Board
Date/Time: Sat, 28 Dec 2024 07:49:33 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-12-14 22:16:05] |
| Sawtooth - Posts: 4143 |
|
The INDEX/MATCH combination is very inefficient in the New Spreadsheets
SC Support is aware of this.keeping locked to the 2 anchors that seems to be challenging.
Try this:1) Use J1 & J2 to enter the anchor points as ZZ price values 2) Put this in a spare Formula Column, e.g. M3: =IF(J$1=H3,ROW(H3)-2,M4) This value will increment as new ZZ legs are added. 3) Put this in a spare Formula Column, e.g. N3: =IF(M3=1,Y3,IF(M3=2,X3,IF(M3=3,W3,IF(M3=4,V3,IF(M3=5,U3,IF(M3=6,T3,0)))))) 4) Use a reference to column N to find the ZZ value of the J1 anchor, e.g. in J3: =INDEX(AA3:AA1002,N3,1) 5) Repeat 2-4 for the other anchor in J2. Date Time Of Last Edit: 2015-12-16 14:33:22
|