Support Board
Date/Time: Sun, 26 Jan 2025 07:49:58 +0000
[Programming Help] - Formula
View Count: 807
[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] |
Sierra Chart Engineering - Posts: 104368 |
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: 4162 |
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: