Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 01:07:43 +0000



Post From: SPREADSHEET - Tracking a Cell

[2015-12-16 06:02:15]
bekitz3 - Posts: 83
4) Use column N to find the ZZ value of the J1 anchor:
=INDEX(AA3:AA1002,N3,1)
Is this formula supposed to go in column N? Because column N is used in step #3?

1) Use J1 & J2 to enter the anchor points as ZZ price values
I'm wondering how this would work if both values are equal? Perhaps it would be better to reference the occurrence instance/# instead of the raw value?