Extracting Values in one list not on the other

Hi there,

I have two lists and I wanted to knock of the common numbers in both the lists. I however have a problem. For eg if A1 to A20 has duplicate numbers say $ 20 comes 3 times and if in the second list fromB1 to B20 $ 20 only occurs once but when I use the the following it knocks off all the $ 20's from the 1st list. Is there any way I can match one to one i,e if a duplicate were to be there then they should still remain in the list.

=IF(COUNTIF($A$1: $A$10,B1)=0,B1," ")

Thanks,
Srini

Originally Posted by sjanaswamy

when I use the the following it knocks off all the $ 20's from the 1st list.

What do you mean "knock off"

What I meant by knocking off was that when I get a list of #s that