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.





robben5 Wrote:
Hi All

I have 2 lists. I want to make a 3rd list by putting in a formula that
will include only the unique items from each of the 2 lists.

Please help


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