Support Board
Date/Time: Mon, 23 Dec 2024 03:08:43 +0000
Index and Match on spreadsheet
View Count: 1764
| [2015-01-01 13:12:54] |
| heavyhucks - Posts: 18 |
|
=INDEX(O4:O36,MATCH(TRUE,INDEX((O4:O36<>""),0),0)) This is the formula that I have entered in the Sierra chart spreadsheet to index the next cell in a row that is not blank. It works perfectly in excel but returns #N/A in Sierra's spreadsheet. I have also tried putting 0's in the column instead of "" and matching cells that are larger than 0 but it still didn't work. Any ideas? |
| [2015-01-01 20:16:53] |
| |
|
This is not supported: INDEX((O4:O36<>""),0) Refer to the documentation here for the INDEX function: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html The documentation applies to New Spreadsheets. 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 |
| [2015-01-01 21:48:43] |
| Sawtooth - Posts: 4141 |
|
Here's a workaround, using another Formula Column, e.g. P: cell P3: =IF(O3>0,1,0) then: =INDEX(O4:O36,MATCH(1,P4:P36,0),1) |
| [2015-01-06 19:35:36] |
| heavyhucks - Posts: 18 |
|
Thanks very much guys!
|
To post a message in this thread, you need to log in with your Sierra Chart account: