Support Board
Date/Time: Mon, 20 Jan 2025 11:11:24 +0000
Post From: Spreadsheet formula for Nth non zero value in column
| [2018-06-07 18:44:53] |
| Sawtooth - Posts: 4157 |
|
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 |