Support Board
Date/Time: Thu, 13 Mar 2025 20:41:11 +0000
Nth Most Recent Non Zero Value
View Count: 170
| [2025-01-18 10:36:39] |
| User467141 - Posts: 3 |
|
Hiya, I'm looking for a way to find the (variable)th most recent non zero value in spreadsheets. I have the Study "Swing High and Swing Low" loaded and would like to be able to make decisions based on that and some other factors. Therefore i need a column with the most recent non zero value (which is a function in spreadsheets) and a column with the nth most recent non zero value. Is it possible to adjust the function where mostrecentnonzerovalue(range,nth) is a possibility, so that it returns the nth most recent non zero value? For example 0 0 0 10 0 0 20 0 0 40 If the function could be mostrecentnonzerovalue(A1:A10,1) the cell would show 10, if the function would be mostrecentnonzerovalue(A1:A10,2) the cell would show 20, mostrecentnonzerovalue(A1:A10,3) would show 40. Or is there a workaround i don't know about yet? Hope this makes my question clear! Thanks in advance. |
| [2025-01-18 23:04:16] |
| User690628 - Posts: 13 |
|
+1, would like to know how to do this or request the option. It would be extremely helpful.
|
| [2025-02-04 05:08:54] |
| User690628 - Posts: 13 |
|
Any possibility for this? Would be hugely beneficial, thanks.
|
To post a message in this thread, you need to log in with your Sierra Chart account: