I need to find a specific number from a list of numbers within a range of
cells.

For example:

Column B
1
2
3
4
5
10,11
9,8
12
11

I need to find if 11 is in the list. Find if shows each cell with an "11"
but I can't get a function to work. I tried =countif(b$2:b$16,"11")0 but it
doesn't work. I can treat the cells as a number or text, whichever will make
the function work. Basically, I am trying to fiind if a value exists in a
column and reutrn a yes/no to create an automatic proof reading tool.