Hi, I have multiple values in a column and I would like to find out a way to count them, how many times does each value occur.
If this is possible at all, I got kind of close to the solution by using a pivot table and merging the values but don't know a way to display count.
This would save me a lot of time since I have many tables with these values.
It's really important to me to display the original value and the count number.
Example:
10754005
10024005
10444005
10024005
10024005
10024005
10024005
10024005
Result:
10754005 - 1
10024005 - 6
10444005 - 1
Thanks.
Bookmarks