Support Board
Date/Time: Mon, 13 Jan 2025 18:48:04 +0000
Find the Nth instance of a number in a spreadsheet column using spreadsheet functions?
View Count: 837
| [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: