Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 06:29:52 +0000
Post From: Spreadsheet formula for Nth non zero value in column
| [2018-06-07 17:47:23] |
| aknsyu71@gmail - Posts: 49 |
|
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 |