I have a question on count. I have a spread sheet with like
A B C
06 01 0
03 02 1
11 03 2
14 04 0
15 05 1
08 06 2
07
05
24
18
31
03
06
02

ColA is prefilled ColB has the number 01 to 50 in asc order and ColC is
lookup up of entire colA by counting how many times I have 01, how many 02,
03 and so on.
Is there a easy way to do this ?

Thanks in advance.
Andy

One way:

C1: =COUNTIF(A:A,B1)

Copy down to C50

In article ,
Andy wrote:

I have a question on count. I have a spread sheet with like
A B C
06 01 0
03 02 1
11 03 2
14 04 0
15 05 1
08 06 2
07
05
24
18
31
03
06
02

ColA is prefilled ColB has the number 01 to 50 in asc order and ColC is
lookup up of entire colA by counting how many times I have 01, how many 02,
03 and so on.
Is there a easy way to do this ?

Thanks in advance.
Andy

thanks

"JE McGimpsey" wrote:

One way:

C1: =COUNTIF(A:A,B1)

Copy down to C50

In article ,
Andy wrote:

I have a question on count. I have a spread sheet with like
A B C
06 01 0
03 02 1
11 03 2
14 04 0
15 05 1
08 06 2
07
05
24
18
31
03
06
02

ColA is prefilled ColB has the number 01 to 50 in asc order and ColC is
lookup up of entire colA by counting how many times I have 01, how many 02,
03 and so on.
Is there a easy way to do this ?

Thanks in advance.
Andy