Support Board
Date/Time: Sat, 30 Nov 2024 03:37:56 +0000
Post From: Spreadsheet - Returning value of first non zero cell in a column
| [2023-01-02 01:35:30] |
| Sawtooth - Posts: 4123 |
|
Use another Formula Column to get a TRUE when column AB has a value, like this e.g. in P3: =AB3>0 Then use a formula like this: =INDEX(AB3:AB50,MATCH(1,P3:P50,0),1) But there is an easier way: =MOSTRECENTNONZEROVALUE(AB3:AB50) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function |