See if this is what you need, if something exists in colomn B that is not in
column A it will return it. put this in column C and copy down
=IF(COUNTIF($A$1:$A$6,B1)=0,B1,"")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"mouhammmmmmmad" wrote:

there are two columns containing numbers and have common numbers i want to
have the uncommon numbers in a seperate column