Support Board
Date/Time: Thu, 02 May 2024 05:51:56 +0000
Post From: lowest value in a column
[2020-03-24 12:38:09] |
Sawtooth - Posts: 3989 |
Use the MIN function. If you want to exclude Zeros, use the MINZ function. If you want to include only those values Greater than a given value, use the MING function. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MIN_Function. To also limit the number of rows, use the OFFSET function. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#OFFSET_Function Try something like this, e.g. in cell P3: =MINZ(E3:OFFSET(E3,x,0)) where x is the number of rows. Date Time Of Last Edit: 2020-03-24 13:25:45
|