Counting Occurance of Particular Digit

Originally Posted by shg

The application of Ron's formula to your usage would be =IF(COUNTIF(B2, "*" & MID(A2,1,2) & "*" ), F1, "X"), which returns 8.

Thanks alot Mod.

I tried this "* MID(A2,1,2) *" didnt work...Thanks alot for pointing out..:P