Combine two lists into a list of unique items

**mkvassh** · 03-24-2010, 08:56 AM

I want to combine two lists with data into one list with unique lines. There are several columns in the two lists, but the header row is the same.

A VBA-answer is OK, as well as help columns, array formulas etc. Anything by other words :-)

**ChemistB** · 03-24-2010, 10:06 AM

Not enough info.

What do you want to do with duplicates? Do you want to combine any lines (eg. in list1 there's info in col 1 and col 3 and in list2 there's info in col1 and 2)? What's preventing you from simply pasting the second list underneath the first list?

**mkvassh** · 03-25-2010, 04:41 AM

Sorry if I was not clear enought. See a simple example below.

List 1

First name Second Name
Ole Olsen
Hans Hansen
Magne Nilsen

List 2

First name Second Name
Ole Olsen
Hans Hansen
Tor Andersen

Unique list

First name Second Name

Ole Olsen
Hans Hansen
Magne Nilsen
Tor Andersen

I hope this explain what I need.

**ChemistB** · 03-25-2010, 11:20 AM

Here's how I would do it;
Assuming List1 on sheet1A2:B500, List2 on Sheet2 A2:B300
In a column (C) next to List1, =A2&B2 dragged down to concatenate the first and last names.
In A column (C) next to List2 =ISNUMBER(MATCH(A2&B2,$C$2:$C$500,0))
Then Filter List2 by Column C on True and copy and paste those rows over to List 1. Does that work for you?