Search code examples
excelexcel-formulacountnumbers

Count how often a number occurs in the cell excel

I have a list of numbers in excel for example:

11111
12345
23222
13111
11511
92099

And I want to count the number of occurrence of the numbers So it will be like this

11111 5
12345 0
23222 4
13111 4
11511 4
92099 3
Solution

  • =LET(ξ,MAX(LEN(A1)-LEN(SUBSTITUTE(A1,SEQUENCE(10,,0),""))),IF(ξ=1,0,ξ))