Excel 2007 Combining two tables

  • Thread starter Thread starter Runar
  • Start date Start date
R

Runar

I have 2 tables which both are a function of time. The number of lines in the
tables are different and the time span is not regular . I would like to:

- merge this 2 tables
- after merging there will some timestamp which are double. Get the correct
data set and get rid of the extra timestamp and data
- fill out the missing dataset by correlation
 
Hi,

attached is an example.

Tabel 1 Tabel 2

Time Var 1 Time Var 2
01:00:00 1 01:00:00 10
01:00:10 2 01:00:05 15
01:00:20 3 01:00:10 20
01:00:30 4 01:00:25 30
01:00:30 40
Merge them to one tabel:
Time Var 1 Var 2
01:00:00 1 10
01:00:05 ? 15
01:00:10 2 20
01:00:20 3 ?
01:00:25 ? 30
01:00:30 4 40

The '?' has to be filled inn by iteration and correlation between the
variables.


Ashish Mathur skrev:
 
Hi,

I am not quite sure of the co-relation but you can use the VLOOKUP()
function to combine the Var 1 and Var 2 values,

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top