Support Board
Date/Time: Tue, 26 Nov 2024 09:20:55 +0000
Post From: Study Name for Value # bars ago ?
[2014-04-22 19:35:57] |
Sawtooth - Posts: 4120 |
That requires different formulas. Try this: K3: =INDEX(C$3:INDIRECT("C"&$J$30+2),O3,1) L3: =INDEX(D$3:INDIRECT("D"&$J$30+2),O3,1) O3: =IF(ROW()=3,RIGHT(ADDRESS($K$1+1,1,3)),O2+1) K1: # of bars ago |