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


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

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

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