Support Board
Date/Time: Sun, 24 Nov 2024 05:24:51 +0000
Post From: S/Sheet Study - Formula returns #inval! error
| [2013-09-22 16:17:00] |
| User37170 - Posts: 29 |
|
Still struggling to get any sense out of my s/sheet study attempts. Using the simple MA crossover study cannot get Toms formula to work: I tested it on a standalone s/sheet - works perfectly But not in SC s/sheet. =COUNTIF(INDEX(X3:X1002,MATCH(INT(A3),Y3:Y1002,-1),1):INDEX(X3:X1002,MATCH(INT(A3)-1,Y3:Y1002,-1),1),TRUE) Also this formula stays the same regardless of which cell I paste it into No relative referencing. Odd! Any suggestions pleeze. |