Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 04:41:59 +0000
Post From: Study Name for Value # bars ago ?
| [2014-04-22 19:35:57] |
| Sawtooth - Posts: 3993 |
|
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 |