Counting data

[tiredofit]

Assume I have this column of data:

a
b
c
d
e
a
b

If I type in cell D1:

=COUNTIF(A:A,A1)

and copy the formula down, I get:

2
2
1
1
1
1
1

which is correct.

But what I am seeking is:

1 of 2 ' because it's the 1st a of 2
1 of 2 ' because it's the 1st b of 2
1 of 1 ' because it's the only c
1 of 1 ' because it's the only d
1 of 1 ' because it's the only e
2 of 2 ' because its the 2nd a of 2
2 of 2 ' because its the 2nd b of 2

How can this achieved?

Thanks

 

[tyija1995]

Hey,

How about:
=COUNTIF($A$1:A1,A1) then drag that down

 

[Fluff]

How about
=COUNTIF(A$1:A1,A1) & " of " &COUNTIF(A:A,A1)

 

[tiredofit]

Brilliant to both.

My weekend's started early!

Have a great one yourselves.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[tyija1995]

Thanks, you have a good one too! Sorry I missed the extra bit " of " & next formula - thought you just wanted the numbers