Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 08:23:12 +0000

How to Post a Message for Support

Post From: spreadsheet index question

[2018-07-11 00:18:45]
[Go To First Post]
Sawtooth - Posts: 4000
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)