Thanks a ton!!




CaptainQuattro Wrote:
One way to do this is as follows:

1) Assuming list 1 is in Column A and List 2 is in column B, create a
list in column C that is a combination of Lists 1 and 2 as follows:

copy the active cells in column A and paste them to cell C2
copy the active cells in column B and paste them to the first blank
cell in Column C.

2) in cell D2 enter the following formula

=IF(ISNA(MATCH(C2,C$1:C1,0)),C2,"")

and copy down as many rows as needed.

YOU COULD ALSO USE DATA FILTER ADVANCED FILTER ON THE COMBINED LIST
IN COLUMN C AS FOLLOWS:

Use the letter C as the Column Header in Cell C1
In Cell E1 enter C.
In Cell E2 enter *.

Click Data Filter Advanced Filter

Choose: Copy to another location
List Range $C:$C
Criteria Range E1:E2
Criteria range E1:E2
Copy to F1
Check: Unique records only

Click OK




--
robben5
------------------------------------------------------------------------
robben5's Profile: http://www.excelforum.com/member.php...o&userid=36014
View this thread: http://www.excelforum.com/showthread...hreadid=557979