Count amount of occurances within a cell

[cmb80]

Hi all, I'd like to find how many instances of numbers below 50 occur in a specific cell.

For instance the cell may contain 10 34 52 59 66

The problem is, this sis stored as a text string. They maybe as many as 12 different numbers within a cell.

In the above example, the answer would be 2

[zbor]

Try this UDF:

Please Login or Register  to view this content.

Use it as:

=COUNT_WITHIN_STRING(A1, 50)

Where A1 is range of the cell
50 is criteria for less than equal that number (can be changed)

[cmb80]

Great thank you