Advanced Data Filter

A

Asad

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;
 
B

Bob Phillips

What does this have to do with Advanced Data Filter?

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

and copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top