Merging two lists

F

Florianbur

Hi all,

i have a list, sorted by column A, with identifcation numbers.

Then I have another list, also sorted by column A, also wit
indentification lists, but this list also has further info in column
B, C, D etc...


Now I would like to add the info of list 2 to list 1.
If the identification number of list 2 already exists in list 1, th
further colums shall be added behind that one.
If the identification number does not exist, it shall be added at th
bottom of list 1 with the corresponding info.

There are identifaction numbers in both lists which do not apear in th
other list.

I hope this is understandable, could someone pls help me
 
B

Bernie Deitrick

Florian,

Unless I'm missing something, I think it's pretty simple.

If the data has the same information in the same column order, copy the
second list below the bottom of the first list, then sort based on column A.

If the unique values from the second list _must_ be copied to the bottom of
the first list, you could use a formula in the first open column:

=COUNTIF(OtherSheet!A:A,A1) = COUNTIF(A:A,A1)

and copy down to match your merged data. Then sort based on this column
first (Ascending) so that the TRUEs go to the bottom, and on column A as the
second key.

HTH,
Bernie
MS Excel MVP
 
F

Florianbur

Das hat mir schon einmal geholfen, danke schön, noch schöner wäre e
gewesen wenn die doppelte Datensätze automatisch zusammengeführ
würden, so habe ich die dann immer zweimal drinnen, aber pass
schon...

Gracia
 
B

Bernie Deitrick

The sorting should bring the double records together automatically.

HTH,
Bernie
MS Excel MVP
 
Top