Excluding a column from range in COUNTIF function

[connole99]

Does anyone know how to exclude a column from a range in the COUNTIF
function? Example: =(COUNTIF($A:$N,B1)=0)*(B1<>"") but I want to exclude the
B column from the range. Any suggestions?? Thanks

 

[Eduardo]

Hi,
try

=(COUNTIF($A:$A,B1)=0)*(B1<>"")+COUNTIF($C:$N,B1)=0)*(B1<>"")

 

[connole99]

Hello,
Thanks a million but worked!!!! You're a star, thank you

 

[Eduardo]

You are very welcome, thank you for the feedback

Hello,
Thanks a million but worked!!!! You're a star, thank you