| T O P I C R E V I E W |
| DerekK |
Posted - 08/16/2018 : 2:48:03 PM
Hello
I have two columns of data (dates and values) and I want to find a function or column formula to copy the dates and values for a specific range of dates into another set of columns. I have the start and stop dates as user parameters in the header of the column.
Thanks in advance, Derek
Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: win10 |
| 1 L A T E S T R E P L I E S (Newest First) |
| Hideo Fujii |
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. |
|
|
