Support Board
Date/Time: Sat, 10 May 2025 01:01:13 +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. |