software

I want to look in column A and column B for matching part numbers and in
column C have a formula that will display any part number from column A that
is not in column B. I have 3450 part numbers to go through as new numbers are
added every week.

Column A Column B
G0015G0015
G0092G0092
G0123V1G0123V1
G0124G0124
G0125V2G0125V2
G0325V3G0327V1
G0327V1G0329-2
G0329-2G0331-1
G0331-1G0332V1

Thank you,

Erik

Try using an Advanced Filter...

With your lists in A1: B10, with column headings in the first Row
A1: List_A
B1: List_B

The criteria cells
E1: MatchTest
E2: =COUNTIF($B:$B,A2)=0

The destination cell
C1: List_A

Select columns A:B
lt;Datagt;lt;Filtergt;lt;Advanced Filtergt;
Check: Copy to another location
Check: Unique records only
List range (already selected $A:$B)
Criteria Range: $E$1:$E$2
Copy To: $C$1
Click the [OK] button to create a list of List_A items that are not included
in List_B

Note: the dollar signs and references in the criteria formula

Adjust the range references to suit your situation.

Does that help?

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

XL2002, WinXP-Proquot;Erik Tquot; wrote:

gt; I want to look in column A and column B for matching part numbers and in
gt; column C have a formula that will display any part number from column A that
gt; is not in column B. I have 3450 part numbers to go through as new numbers are
gt; added every week.
gt;
gt; Column A Column B
gt; G0015G0015
gt; G0092G0092
gt; G0123V1G0123V1
gt; G0124G0124
gt; G0125V2G0125V2
gt; G0325V3G0327V1
gt; G0327V1G0329-2
gt; G0329-2G0331-1
gt; G0331-1G0332V1
gt;
gt; Thank you,
gt;
gt; Erik

Hi Erik,

=IF(COUNTIF($B$27:$B$35,A27)=0,A27,quot;quot;)

And fill down.. change range to suit of course.

Returned G0325V3 using your data.

HTH
Regards,
Howard

quot;Erik Tquot; gt; wrote in message
...
gt;I want to look in column A and column B for matching part numbers and in
gt; column C have a formula that will display any part number from column A
gt; that
gt; is not in column B. I have 3450 part numbers to go through as new numbers
gt; are
gt; added every week.
gt;
gt; Column A Column B
gt; G0015 G0015
gt; G0092 G0092
gt; G0123V1 G0123V1
gt; G0124 G0124
gt; G0125V2 G0125V2
gt; G0325V3 G0327V1
gt; G0327V1 G0329-2
gt; G0329-2 G0331-1
gt; G0331-1 G0332V1
gt;
gt; Thank you,
gt;
gt; Erik