Question - excluding from list

[Kuba]

Hello
I have a question for Excel knowers

I have a list of items in column A
I also have a list of items in column B
Some of the items in A and B are duplicates
I'd like to obtain a C column sustaing of items that appear in column A but
NOT appear in column B

Can you help me solving my problem?
Please mail me on priv playa(at)poczta.fm

Kind Regards,
Jakub Lenczowski
Krakow, Poland

 

[Dave Peterson]

Put this in C1:

=if(iserror(match(a1,b:b,0)),a1,"APPEARS IN COLUMN B")
and drag down the column.

Then select column C and
edit|copy
edit|paste special|values

Sort column C (include columns A:B if you want to)
Find the cells that say:
APPEARS IN COLUMN B

and select those cells
edit|delete
shift cells up

 

[Max]

Another play ..

Assuming data in cols A and B, from row1 down

Put in C1:
=IF(ISERROR(SMALL(D,ROW())),"",
INDEX(A:A,MATCH(SMALL(D,ROW()),D,0)))

Put in D1:
=IF(A1="","",IF(ISNUMBER(MATCH(A1,B:B,0)),"",ROW()))

Select C11, copy down to last row of data in col A

Col C will return the required results*, all neatly bunched at the top
*Items in col A not found in col B