Advanced Data Filter

How can I generate a count number series on entries recurring on my
worksheet; e.g i have a data sheet with the following data appearing

x
x
x
a
a
g
g
g
g
g

What I require is a number series to be generated against each occurrence;i.e.

x 1
x 2
x 3
a 1
a 2
g 1
g 2
g 3
g 4
g 5

This is a really heavy worksheet so a simple sort and number generation
would take too much time and this is a recurring daily task.

I would really really appreciate if someone could help me out in this;

What does this have to do with Advanced Data Filter?

In B1, enter =COUNTIF($A$1:$A1,$A1)

and copy down

--

HTH

Bob

"Asad" wrote in message
news
How can I generate a count number series on entries recurring on my
worksheet; e.g i have a data sheet with the following data appearing

x
x
x
a
a
g
g
g
g
g

What I require is a number series to be generated against each
occurrence;i.e.

x 1
x 2
x 3
a 1
a 2
g 1
g 2
g 3
g 4
g 5

This is a really heavy worksheet so a simple sort and number generation
would take too much time and this is a recurring daily task.

I would really really appreciate if someone could help me out in this;