A big problem for me to synchronizate the data in excel

[domodo2000]

there are 6 groups of data,each including a datw col and an 'equity'
col,

the beginning date,ending date,and the date in this period are not the
same

I wanna to match the equity data by the date (that's,make the date
synchronizated)and sum them up each line
(the result of a blank line = the result before it)

for example,there are 2 groups of date

1996-9-2 48550
1996-9-3 49150
1996-9-4 48750
1996-9-5 48650
1996-9-6 52350
1996-9-9 52100
1996-9-10 51550


and

1996-8-30 49800
1996-9-2 49150
1996-9-3 49400
1996-9-9 50350
1996-9-10 50300
1996-9-11 51050
1996-9-12 51650

so I wanna to make the combined data as:

1996-8-30 49800
1996-9-2 49150 48550
1996-9-3 49400 49150
1996-9-4 49400 48750
1996-9-5 49400 48650
1996-9-6 49400 52350
1996-9-9 50350 52100
1996-9-10 50300 51550
1996-9-11 51050 51550
1996-9-12 51650 51550
...
Could anyone here help to make it into reality,please?
Thanks in advance!


+-------------------------------------------------------------------+
|Filename: performence.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3754 |
+-------------------------------------------------------------------+

 

[Bryan Hessey]

I guess I like to do things the hard way, and I don't like VLookUp on
Dates.

As per the attached, I used Lookup on a Text version of the date to add
data to your original column, then reversed the lookup to see what your
first column didn't contain, and inserted new dates.


Check the data, the sheets as I worked through them are available on
request as Set 2, Set 6 etc.

Do some totals on your original data to check the end result.

Also, I added 30/June/1996 instead of 3/June, you can check that 30th
is not required and remove it.

You can obtain a copy of the full .xls used if you email me at
(e-mail address removed)
after you remove remove.remove

Hope this helps

there are 6 groups of data,each including a datw col and an 'equity'
col,

the beginning date,ending date,and the date in this period are not the
same

I wanna to match the equity data by the date (that's,make the date
synchronizated)and sum them up each line
(the result of a blank line = the result before it)

for example,there are 2 groups of date

1996-9-2 48550
1996-9-3 49150
1996-9-4 48750
1996-9-5 48650
1996-9-6 52350
1996-9-9 52100
1996-9-10 51550


and

1996-8-30 49800
1996-9-2 49150
1996-9-3 49400
1996-9-9 50350
1996-9-10 50300
1996-9-11 51050
1996-9-12 51650

so I wanna to make the combined data as:

1996-8-30 49800
1996-9-2 49150 48550
1996-9-3 49400 49150
1996-9-4 49400 48750
1996-9-5 49400 48650
1996-9-6 49400 52350
1996-9-9 50350 52100
1996-9-10 50300 51550
1996-9-11 51050 51550
1996-9-12 51650 51550
...
Could anyone here help to make it into reality,please?
Thanks in advance!

+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3756 |
+-------------------------------------------------------------------+