Support Board
Date/Time: Thu, 19 Mar 2026 10:02:39 +0000
Post From: Spreadsheets; formula works in excel but not in Sierra Charts
| [2015-12-04 10:10:29] |
| SSGill - Posts: 36 |
|
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. |