If you data were in col. A starting in A1 (sorted
ascending), put this in B1 and fill down:
=IF(A1=A2,"",COUNTIF(A:A,A1))
HTH
Jason
Atlanta, GA
-----Original Message-----
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?
action=getinfo&userid=16776
View this thread:
http://www.excelforum.com/showthread...hreadid=319730
.