Hello!
I have a list of numbers (1-60) with some duplicates and I want to organize them so that is shows the frequency that the number appears next to the list of numbers without duplicates.
So for example:
3
4
5
5
4
6
I would want it to show like this:
3 1
4 2
5 2
6 1
I was told to use pivot table but I'm not sure how to go about it.
Many thanks,
Cheers!
Bookmarks