Hi
Is this formula limited to certain text types? I'm trying to get it to
search for example, coloumn B:B which contains references such as ABC-1234
against A1 which contains just 1234.
=COUNTIF(B:B,"*" & A1 & "*")
I cannot get it to work. If it has just the number only iy works fine.