Find Number (1), in like 12,15,31 Ans.should be 3

Closed
Pramod - Sep 11, 2015 at 08:26 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 11, 2015 at 09:06 AM
Hello,

Find Number (1), in like 12,15,31
Ans.should be 3
Any formula to count number


Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 11, 2015 at 09:06 AM
Pramod, Good morning.

Suppose:
A1 --> 12,15,31
B1 --> =LEN(A1)-LEN(SUBSTITUTE(A1,1,""))

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0