Support Board
Date/Time: Tue, 01 Jul 2025 17:12:31 +0000
Post From: lowest value in a column
| [2020-03-24 12:38:09] |
| Sawtooth - Posts: 4231 |
|
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
|