Support Board
Date/Time: Sat, 30 Nov 2024 03:30:41 +0000
Post From: Spreadsheet - Returning value of first non zero cell in a column
| [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. |