Support Board
Date/Time: Tue, 21 Jan 2025 00:54:45 +0000
Post From: spreadsheet index question
| [2018-07-11 00:18:45] |
| Sawtooth - Posts: 4157 |
|
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) |