Support Board
Date/Time: Wed, 14 May 2025 22:49:21 +0000
Post From: spreadsheet index question
| [2018-07-11 00:18:45] |
| Sawtooth - Posts: 4215 |
|
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) |