Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 05:59:34 +0000

How to Post a Message for Support

Post From: Excel error & GetCorrespondingMatch multiple criteria selection

[2016-07-13 18:30:15]
[Go To First Post]
Sawtooth - Posts: 4000
2) Array functions are not supported by Sierra Chart spreadsheets. Workarounds are issue-specific, but usually involve using formulas in multiple columns or cells.

3) Sierra Chart spreadsheets use the conventional Serial DateTime format, same as Excel, where the date is an incrementing integer (starting at 1 on 1/1/1900), and the time of day is a decimal. Use formulas in spare columns to convert.

5) Use a separate column (e.g. D) to assign a 1 in the row when both A1 and B1 are TRUE, then use INDEX/MATCH to return the value in the other column (e.g. E):
=INDEX(E1:E1000,MATCH(1,D1:D1000,0),1)