Hi

With your data layout, try something like:
=IF(COUNTIF($B$1:$B$1000,A1)=0,A1,"")
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.

"snow" wrote in message
...
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:

Hi

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

Andy.

"snow" wrote in message
...
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.