Support Board
Date/Time: Tue, 21 Jan 2025 00:58:38 +0000
Post From: spreadsheet index question
| [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. |