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

Try something like this:

With your 2 lists in Col_A and Col_B, and both lists having a column heading.
I'll use List1 for the Col_A heading and List2 for the Col_B heading.

E1: Test
E2: =ISERROR(MATCH(A2,$B:$B,0))

C1: List1

Select your Col_A list
DataFilterAdvanced Filter
ChecK: Copy to another location
Check: Unique records only
List range: (your already selected List1 data)
Criteria range: $D$1:$D$2
Copy to: $C$1
Click the [OK] button

That should create a list of List1 items that are not included in List2.

Adjust ranges to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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

You've also got responses to your multi-post in microsoft.public.excel, ...
(Please do not multi-post)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kuba" wrote in message
...
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