Merge two worksheets into one with same independent variable

  • Thread starter Thread starter Largo
  • Start date Start date
L

Largo

For merging data for plots, I have two data sets in different
worksheets with time stamps in columns. This is the independant (X)
variable. On one data set (sheet), there's timestamps every second
and in the other, one every 3 seconds. I'd like to merge/append to
the rows of one-second data with the three-second data's rows at
identical times. I can discard any rows that won't fit.

Any solutions?

Largo
 
Why not use a Vlookup from the one-second sheet to find
the corresponding time in the second sheet and return the
data you want to "merge"?

Make sure the 3 second data is in ascending order and
include the "false" variable at the end of the Vlookup.

You can embed the Vlookup within an if statement with the
condition IsNa(Vlookup()) to filter out times not found
in the 3 second data.

Best of Luck,
John T. Riordan
Trett Consulting B.V.
+31-118-420-300
 
Back
Top