Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 04:55:03 +0000
[Programming Help] - spreadsheet index question
View Count: 1096
| [2018-07-10 21:23:48] |
| joer - Posts: 41 |
|
I am trying to search for the first non-zero value in a column of numbers (a7:a19) that is not ordered. In Excel I use the following formula and it returns the result I am looking for: =INDEX(A7:A19,MATCH(TRUE,INDEX(A7:A19<>0,),0)) When I enter this in the new spreadsheets, it returns #ARGS! This used to work in the old spreadsheets. Can you provide the equivalent formula for new spreadsheets? Thank you. |
| [2018-07-11 00:18:45] |
| Sawtooth - Posts: 3993 |
|
Try this: Use a spare column to create a T/F for the non-zero value in column A, e.g.: cells B7:B19 =A7<>0 (Copy/paste formula in column B so that the row increments). Then use INDEX(... MATCH(... to return the first non-zero value in A7:A17 =INDEX(A7:A19,MATCH(1,B7:B19,0),1) |
To post a message in this thread, you need to log in with your Sierra Chart account: