Return the number of occurrences of a number-CodePudding

enter image description here

Right now my issue, is that if I want to search for '263', it returns 0 as I believe excel thinks the entire cell is one string.

I have tried using FIND and SEARCH but it doesn't return the correct number.

CodePudding user response：

I just managed as follows:

=COUNTIF(A1:A6,"*263*")

Be aware that an entry like 263 lab | 263 will yield 2 count results.

CodePudding user response：

So, just to clarify my comment adding to @Dominique :

And, you will notice it only captures 1 for the entry in cell A5

You can try each of the following:

COUNTIF(A1:A6,"*263*")

COUNTIF(A1:A6,"263*")

COUNTIF(A1:A6,"*263")

COUNTIF(A1:A6,263)

Separately to see what happens.