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!

[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 Bryan.Hessey@remove.removeMinterEllison.com
after you remove remove.remove

Hope this helps

**
** Update to this, the OP has received the full .xls (8 meg) file by email, and is currently checking the results generated.

Basically, for each of 6 data sets, a TEXT ("yyyyy"&"mm"&"dd") version of the date was created, and this used to VLookup for additional data. The VLookup was then applied back from the range to the original data to see if any items were missing from column A, and Dates were then included in column A to resolve this.

This was repeated for each additional set, and the finall result was Copy, Paste Special = Values to a new Worksheet.

Totals were added to each column to ensure that no data items were lost.

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!