|
Hideo Fujii
USA
1582 Posts |
 Posted - 08/16/2018 : 4:32:48 PM
|
Hi DerekK,
You can use the Worksheet Query tool for that.
Regarding the query condition, I think you can write like:
A>date(col(A)[UP1]$) AND A<date(col(A)[UP2]$)
when your start and stop dates are in the user parameter, UP1 and UP2, respectively, assuming they are entered as a date string like 5/7/99.
See the detail of the Date function, which converts a date string to the internal Julian date, go to https://www.originlab.com/doc/LabTalk/ref/Date-func .
Regarding the destination of the output, you can set the same worksheet ("Extract to Specific Sheet"), and enter the new column number
at "Column From", in your case 3.
Hope this helps.
--Hideo Fujii
OriginLab
P.S. Note that if you extract the result into the same worksheet, recalculation cannot be set.
Also, even when you extract to a new sheet, by changing the user parameter cannot trigger the recalculation automatically.
To kick in manually, you can select "Change Parameters" to open the Worksheet Query dialog, and press OK to re-proceed. |
Edited by - Hideo Fujii on 08/16/2018 4:59:40 PM |
 |
|
Reduce by date range
