Support Board
Date/Time: Sun, 08 Sep 2024 01:42:16 +0000
Find the Nth instance of a number in a spreadsheet column using spreadsheet functions?
View Count: 792
[2017-05-04 13:26:33] |
cgarrad - Posts: 27 |
Obviously using MATCH finds the first one, how about the second etc.? Is this possible? |
[2017-05-04 17:10:53] |
|
The available spreadsheet functions are here: http://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html We do not think this exists. Possibly we could add that though. 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 |
[2017-05-04 18:38:35] |
cgarrad - Posts: 27 |
I used an extra helper column to verify that match was true on the previous row as part of the formula thus verifying that the next true was a second instance. Works, but only for the 2nd instance. Anyway, more functionality is always good ;-) Thanks. |
To post a message in this thread, you need to log in with your Sierra Chart account: