software

In list1 there is many phonenumbers.
In list2 there is also many phonenumbers.
I want to remove every phonenumbers that is in list2 from list1.

Hi

Have a look he
www.cpearson.com/excel/duplic...tractingCommon

Andy.

quot;snowquot; gt; wrote in message
...
gt; In list1 there is many phonenumbers.
gt; In list2 there is also many phonenumbers.
gt; I want to remove every phonenumbers that is in list2 from list1.
Hi Andy.
Thanks for quick replay.
I took a look at the web-side you refer to. But I still not get it right.

Column A Column B Colum C
3256 1234 2541
2541 3256
1234

What formula do I write in Colum C to get if right?Andy skrev:

gt; Hi
gt;
gt; Have a look he
gt; www.cpearson.com/excel/duplic...tractingCommon
gt;
gt; Andy.
gt;
gt; quot;snowquot; gt; wrote in message
gt; ...
gt; gt; In list1 there is many phonenumbers.
gt; gt; In list2 there is also many phonenumbers.
gt; gt; I want to remove every phonenumbers that is in list2 from list1.
gt;
gt;
gt;

Hi

With your data layout, try something like:
=IF(COUNTIF($B$1:$B$1000,A1)=0,A1,quot;quot;)
As you fill this down, column C will extract the numbers from column A that
don't exist in column B.

Hope this helps.
Andy.

quot;snowquot; gt; wrote in message
...
gt; Hi Andy.
gt; Thanks for quick replay.
gt; I took a look at the web-side you refer to. But I still not get it right.
gt;
gt; Column A Column B Colum C
gt; 3256 1234 2541
gt; 2541 3256
gt; 1234
gt;
gt; What formula do I write in Colum C to get if right?
gt;
gt;
gt; Andy skrev:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Have a look he
gt;gt; www.cpearson.com/excel/duplic...tractingCommon
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;snowquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; In list1 there is many phonenumbers.
gt;gt; gt; In list2 there is also many phonenumbers.
gt;gt; gt; I want to remove every phonenumbers that is in list2 from list1.
gt;gt;
gt;gt;
gt;gt;
quot;snowquot; wrote:
....
gt; Column A Column B Colum C
gt; 3256 1234 2541
gt; 2541 3256
gt; 1234
gt; What formula do I write in Colum C to get if right?

Another play to try, using non-array formulas

Put in C1:
=IF(ISERROR(SMALL(E:E,ROW(A1))),quot;quot;,
INDEX(A:A,MATCH(SMALL(E:E,ROW(A1)),E:E,0)))

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

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

Col C will return the required results all neatly bunched at the top
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---