I can't get it to return a "Yes" for anything but 11 in my trials.
How is your data setup where you get "Yes" for a 1.

I assume you have altered the formula to match your actual data
rather than the example you posted. Please post a copy of the new formula
along with an explanation of the nature of your data.

Regards
Martin


"Lost in Microbiology" wrote
in message ...
This was working, but now I am finding it will say "Yes" for a 1 if there
is
a 11,12,13,etc. in the column. Is there a way around this? Should I change
the column to text?

Thanks

"MartinW" wrote:

Woops that should be

=IF(COUNTIF(B$2:B$16,"*11*")+COUNTIF(B$2:B$16,11) 0,"Yes","No")

HTH
Martin