Array threshold scan

[hiNI]

Hello,

I would like to scan the data in the Data.txt file from the last entry scanning up, and return the value of the x,y point the first time where the y data is closest to +100 or -100. Please see the graph.png file for clarification.  

Any help will be greatly appreciated!

Thanks,

hiNi

[.aCe. · Accepted solution]

I cannot get the negative threshold to work! So had to do some data manipulation.

But here is a working version, you can then do a compare to see which is the greater one.

If it was just positive numbers, threshold array function will also work. Here it is: