Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 12:13:55 +0000
Post From: Spreadsheets; formula works in excel but not in Sierra Charts
| [2015-12-04 10:10:29] |
| SSGill - Posts: 35 |
|
Thanks! verified it works. One additional formula I am having difficulty with is; =INDEX(ap3:ap1000, MATCH(FALSE, ISBLANK(ap3:ap1000), 0)) I am trying to return the first non-blank value; I referred to the SC documentation, and also used isnull() and isempty. All return a #NA. This does work in excel if I press the Ctrl, Shift Enter after typing my formula. |