Need help with MWE's Frequency Count of Selection

[succorso]

The article/solution is Frequency Count of Selection kb 406. (won't let me post the link).

I am trying to count how many unique numbers are in a selection and the frequency of those numbers. The solution I linked to is the closest thing I could find but it's not counting the longer numbers. Only the shorter ones.


The data I am running it against looks like this

13100005
13100005
13100005
13100005
13100005
13100005
13100006
123
123
114
123456666

However, the function only seems to work on the numbers 123,123,114. Not the longer ones. I end up with this result:

Value Count
0 1
0 1
0 1
0 1
0 1
0 1
0 1
0 1
114 1
123 2

Is there any way I can fix this? Thanks very much in advance for your help.

[BobBarker]

Are you using a long?

[succorso]

I didn't even know their were different integer types in Excel. I can format the column in any way I need to to make the function work, including text.

[succorso]

Is there anyone that can give me a hand with this? It doesn't seem to work when counting numbers over 6 digits. MWE?

Thanks.