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" <(E-Mail Removed)> wrote in message
newsACEB4B5-1F4A-4A7A-9D39-(E-Mail Removed)...
> 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;
>