Support Board
Date/Time: Sat, 28 Dec 2024 07:24:40 +0000
Post From: SPREADSHEET - Tracking a Cell
| [2015-12-16 14:46:32] |
| Sawtooth - Posts: 4143 |
|
Is this formula supposed to go in column N? Because column N is used in step #3?
It goes in any non-repeating cell, e.g. J3.Previous post edited. I'm wondering how this would work if both values are equal?
It doesn't work with equal values without an additional condition. Include an IF statement in your line drawing formula that draws a horizontal line if both are equal. Perhaps it would be better to reference the occurrence instance/# instead of the raw value?
The instance# will increment with each new ZZ leg. I was referencing the ZZ price so that the instance# increments automatically.
|