Merging 2 lists in excel 97

  • Thread starter Thread starter assws
  • Start date Start date
A

assws

I have looked around in this site and found partial answers but not t
the full problem.

I have 2 list of name and score.

List 1 is the master list with a old score
List 2 is an updated list with a new score.

I want to compile a new master list with the new score.

The problems I have run into are:

1) A name can be on both lists if this happens I want the score fro
the new list
2) A name can be on the old list only and I would want to keep the ol
score
3) A name can be on the new list only and I would want the new score.

I have attached a dummy sheet as an exampl

Attachment filename: for_excel_forum.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42217
 
assws,

No need for a dummy sheet....

Let's say that your old list is in A1:B100. In C1, type
= MATCH(A1,
then click on your new list's first column, then type

, False)

and hit enter.

Copy that formula down to C2:C100, then sort A1:C100 based on column
C.

Copy the cells in column A and B where the formula in C returns an
error (which means the value in column A isn't in the new list). Then
simply add the values to the bottom of the new list as values, sort
the new list and the additions, and you're done.
 
Back
Top