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
Bookmarks