Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 30 Apr 2024 11:01:51 +0000
Post From: Formula
| [2019-02-15 20:01:08] |
| User228927 - Posts: 55 |
|
I am using this formula-=INDEX(K$3:K$100,MATCH(TRUE,K3:K100<>0,0)) to find first non zero cell entry in spreadsheet study. The formula works in a regular excel spreadsheet, for arrays have to press Ctrl+Shift+Enter, but doesn't seem to work in the spreadsheet study spreadsheet. Will formulas like this not work in Sierra Spreadsheet Study.
|