succorso
02-25-2011, 10:03 AM
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.
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.