Hi all, I'm a novice with Origin and have what I think is a simple question. I'd like to use the list function to find the row index immediately proceeding the row index that satisfies the equation. So for example:
r2(row2)/60; //this is the value I want
-- range r1 = "Processed Data"!A; range r2 = "Processed Data"!D; row = List((r1<0),r1); row2 = row-1;
I want it to search Column A for the first value below 0 and then use that index to return the value one row above it. This doesn't work as I've written it.
Anyone have a simple solution?
Thanks in advance!
Origin Ver. and Service Release (Select Help-->About Origin): Operating System: Origin 2015
List function looks for the exact value. If your data is monotonic, you can try Index function (or even Countif), otherwise, I think the best way is to loop through the vector, break the loop when first negative detected.