Excluding a column from range in COUNTIF function
You are very welcome, thank you for the feedback
"connole99" wrote:
Hello,
Thanks a million but worked!!!! You're a star, thank you :)
"Eduardo" wrote:
Hi,
try
=(COUNTIF($A:$A,B1)=0)*(B1<"")+COUNTIF($C:$N,B1)= 0)*(B1<"")
"connole99" wrote:
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 :)
|