Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 11:33:02 +0000

How to Post a Message for Support

Post From: Spreadsheets; formula works in excel but not in Sierra Charts

[2015-12-04 13:21:28]
[Go To First Post]
Sawtooth - Posts: 3992
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