Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 19 Apr 2024 02:55:51 +0000
[Programming Help] - lowest value in a column
View Count: 471
| [2020-03-24 05:49:42] |
| User917679 - Posts: 76 |
|
In spreadsheet programming, what would be an efficient way to go about finding the lowest value out of x number of rows in a given column? I found this: SMALL(Numbers, NthSmallest), but how would I go about using it to do the above(Or should I even use it at all..)? |
| [2020-03-24 12:38:09] |
| Sawtooth - Posts: 3973 |
|
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
|
| [2020-03-24 13:57:01] |
| User917679 - Posts: 76 |
|
Try something like this, e.g. in cell P3:
=MINZ(E3:OFFSET(E3,x,0)) where x is the number of rows. Ok and from here, how would you obtain the "cell address" that houses this minimum number? |
| [2020-03-24 14:30:46] |
| Sawtooth - Posts: 3973 |
|
how would you obtain the "cell address" that houses this minimum number?
In another Formula Column:=P3<>P4 This marks the row with a '1' where the lowest value occurs. Date Time Of Last Edit: 2020-03-24 15:39:39
|
To post a message in this thread, you need to log in with your Sierra Chart account: