Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 30 Apr 2024 09:59:15 +0000
[Programming Help] - Formula
View Count: 723
| [2019-02-15 20:01:08] |
| User228927 - Posts: 55 |
|
I am using this formula-=INDEX(K$3:K$100,MATCH(TRUE,K3:K100<>0,0)) to find first non zero cell entry in spreadsheet study. The formula works in a regular excel spreadsheet, for arrays have to press Ctrl+Shift+Enter, but doesn't seem to work in the spreadsheet study spreadsheet. Will formulas like this not work in Sierra Spreadsheet Study.
|
| [2019-02-17 06:57:53] |
| |
|
No, this formula will not work. For what is supported with these functions, refer to: Spreadsheet Functions: Available Functions Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2019-02-17 14:56:59] |
| Sawtooth - Posts: 3985 |
|
Try this in a Formula Column, e.g. in L3: =IF(K3<>0,K3,L4) This works in a static cell, e.g. H3, but you must first use a Formula Column to create a boolean TRUE: L3: =K3<>0 H3: =INDEX(K3:K100,MATCH(1,L3:L100,0),1) Or this in a Formula Column, e.g. M3: L3: =K3<>0 M3: =INDEX(K3:K100,MATCH(1,L3:L100,0),1) Date Time Of Last Edit: 2019-02-18 22:50:51
|
| [2019-02-18 19:56:40] |
| User228927 - Posts: 55 |
|
yes, that works. Thanks
|
| [2019-02-18 19:56:40] |
| User228927 - Posts: 55 |
|
yes, that works. Thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: