Support Board
Date/Time: Mon, 20 Jan 2025 11:12:36 +0000
Post From: Spreadsheet formula for Nth non zero value in column
| [2018-06-07 17:47:23] |
| aknsyu71@gmail - Posts: 54 |
|
Hi, I cannot get this to work, hope someone will have the answer please. Data in column is: 0 0 56 0 0 0 89 0 0 I am trying to reference the 89 value (2nd non zero value). This works in excell with data in column C: =INDEX(C1:C10,SMALL(IF(C1:C10<>0,ROW(C1:C10)),2)) Would anyone know the correct formula for Sierra spreadsheets please. Thank you |