software

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
Datagt;Filtergt;Advanced 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-Proquot;Kubaquot; wrote:

gt; Hello
gt; I have a question for Excel knowers
gt;
gt; I have a list of items in column A
gt; I also have a list of items in column B
gt; Some of the items in A and B are duplicates
gt; I'd like to obtain a C column sustaing of items that appear in column A but
gt; NOT appear in column B
gt;
gt; Can you help me solving my problem?
gt; Please mail me on priv playa(at)poczta.fm
gt;
gt; Kind Regards,
gt; Jakub Lenczowski
gt; Krakow, Poland
gt;
gt;
gt;

You've also got responses to your multi-post in microsoft.public.excel, ...
(Please do not multi-post)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Kubaquot; gt; wrote in message
...
gt; Hello
gt; I have a question for Excel knowers
gt;
gt; I have a list of items in column A
gt; I also have a list of items in column B
gt; Some of the items in A and B are duplicates
gt; I'd like to obtain a C column sustaing of items that appear in column A
but
gt; NOT appear in column B
gt;
gt; Can you help me solving my problem?
gt; Please mail me on priv playa(at)poczta.fm
gt;
gt; Kind Regards,
gt; Jakub Lenczowski
gt; Krakow, Poland
gt;
gt;