Support Board
Date/Time: Sat, 10 May 2025 01:28:46 +0000
Post From: Spreadsheets; formula works in excel but not in Sierra Charts
| [2015-12-04 13:21:28] |
| Sawtooth - Posts: 4214 |
|
CSE formulas are not supported in spreadsheet studies. You'll need to use an additional Formula Column, e.g. column O, to mark all blanks, e.g with a 1, that your FALSE produced, then use something like this: =INDEX(AP3:AP1002,MATCH(1,O3:O1002,0)) This will result in the most recent occurrence. Date Time Of Last Edit: 2015-12-04 13:38:29
|