Support Board

Date/Time: Sat, 18 May 2024 08:16:25 +0000

Post From: spreadsheet index question

[2018-07-10 21:23:48] Link To Thread - Link To Post [Go To First Post]
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.