HI, I have a vector (as a column in Excel) as follows:

4
4
3
6
3
5
5
3
2
1

Now I want to calculate the frequency of each value (or occurance). I
first sort the vector as follows:

1
2
3
3
3
4
4
5
5
6

Then for the small data set I manually calculate the number of
occurance, which is follows:

1 1
2 1
3
3
3 3
4
4 2
5
5 2
6 1

Note the second column shows the number of occurance. I wonder if there
is any automatical way to do it. Many thanks.


--
bjg
------------------------------------------------------------------------
bjg's Profile: http://www.excelforum.com/member.php...o&userid=16776
View this thread: http://www.excelforum.com/showthread...hreadid=319730