'Origin’s LabTalk loop through a dataset and find nearest value in another dataset
So, let’s say I have two worksheets wks1 and wks2. I’d like to loop through a column of wks1 and for each cell value x1 I need to find the cell value x2 with row index r of column1 of wks2 that is the closest to x1. Then when that’s been done I’d like to take rows [r-5;r+5] and find the maximum value of column2 of wks2. Then I’d like to have a separate worksheet that stores all the columns of wks2 with the corresponding rows of wks2, that have the maximum value within range of [r-5;r+5]. Is this doable in LabTalk? If yes, how do I start?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
