Question - excluding from list

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

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

Kuba wrote:
>
> 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

Another play ..

Assuming data in cols A and B, from row1 down

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

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

Select C1:D1, 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kuba" <playa@poczta.fm> wrote in message
news:dtf1l2$kan$1@news.interia.pl...
> 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
>
>
>