Support Board
Date/Time: Wed, 14 May 2025 07:34:30 +0000
Post From: Spreadsheet formula for Nth non zero value in column
| [2018-06-07 18:44:53] |
| Sawtooth - Posts: 4214 |
|
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 |