Support Board
Date/Time: Sat, 30 Nov 2024 03:46:48 +0000
Spreadsheet - Returning value of first non zero cell in a column
View Count: 430
| [2023-01-01 23:35:28] |
| User589284 - Posts: 6 |
|
Hi. In a Spreadsheet formula, I am trying to get the value of first non zero cell in a column (from top to bottom). Tried this formula that works in Excel, but it doesn't work on the Sierra Spreadsheet: =INDEX(AB5:AB50,MATCH(TRUE,INDEX(AB5:AB50<>0,),0)) Could you kindly suggest an alternative formula to achieve that result? Thank you p.s. only raising as I could not find a solution on the support forum nor figure out from the Spreadsheet Functions page. |
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: