Prev: Adding data from multiple cell and linking to a new worksheet
Next: Counting Characters In A String
From: Asad on 29 Apr 2010 03:28
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;

From: Bob Phillips on 29 Apr 2010 03:39
What does this have to do with Advanced Data Filter?

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

and copy down

--

HTH

Bob

"Asad" <Asad(a)discussions.microsoft.com> wrote in message
news:DACEB4B5-1F4A-4A7A-9D39-47B0C083DDBF(a)microsoft.com...
> 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;
>


 | 
Pages: 1
Prev: Adding data from multiple cell and linking to a new worksheet
Next: Counting Characters In A String