Help with IF Formula

R

robben5

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
 
C

CaptainQuattro

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.
 
R

robben5

Thanks a ton!!



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
Click to expand...
 
Top