Hi, I am glad I have discovered this post, because I am new to excel and on a
steep learning curve due to the requirements of my work.
I have a large one-column list of values which includes duplicate values. i
would like to calculate and display the number of times each value occurrs.
for example.
1
2
4
4
6
The result should display something like 1=1, 2=1, 4=2, 6=1.
Any help would be appreciated.
Thanks. Mark =)