Extracting Values Common To Two and On One List And Not Another

[Hau]

Hi,

Could you please help me to join these two functions?
=IF(COUNTIF($A$1:$A$10,B1)>0,B1,"") and =IF(COUNTIF
($A$1:$A$10,B1)=0,B1,"")



Regards,

 

[Torgeir Aasen]

Hi Hau
Try this:
=IF(COUNTIF($A$1:$A$10,B1)>=0,B1,"")