Is it possible to count the number of instances of a specific number in a cell, if the cell has multiple, comma separated numbers in it.
Eg: 1,19,20
I tried using =COUNTIF(A$2:A$4,"*"&C2&"*")+COUNTIF(A$2:A$4,C2)
but is appears to count 11 as 1, if there is other content in the cell. It also could not distinguish between 112,1 and 11,1.... it would count both of these as 11.
Any ideas, greatly appreciated.
Eg: 1,19,20
I tried using =COUNTIF(A$2:A$4,"*"&C2&"*")+COUNTIF(A$2:A$4,C2)
but is appears to count 11 as 1, if there is other content in the cell. It also could not distinguish between 112,1 and 11,1.... it would count both of these as 11.
Any ideas, greatly appreciated.