Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 22:14:38 +0000
Post From: Spreadsheet formula for Nth non zero value in column
| [2018-06-07 18:44:53] |
| Sawtooth - Posts: 3980 |
|
Try this: Use a spare column to find non-zero values, e.g., column D: =C1>0 and copy down an incrementing formulas to rows below, e.g. =C2>0 =C3>0 etc. Then use this to return the second non-zero value in column C: =INDEX(C1:C10,NMATCH(2,1,D1:D10,0),1) Here's the documentation on the NMATCH function: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#NMATCH_Function |