Counting number of times unique id appears

Hi,

I'm using excel 2003 and I have a document that needs to have the number of times a unique id appears in column B written in column C next to it.

This is how it looks in the beginning and I have used the | symbod as the column separator.

LineNumber|Order|OrderLine|ProductID
1|1123568||ivg2
2|1123744||ivg2
3|1123744||ivg4
4|1129874||ivg2
5|1132558||ivg2
6|1132642||ivg2
7|1132642||ivg4
8|1132642||ivg5
9|1132642||ivg7
10|1123291||ivg1

After VB code is applied it would look as below.

LineNumber|Order|OrderLine|ProductID
1|1123568|1|ivg2
2|1123744|1|ivg2
3|1123744|2|ivg4
4|1129874|1|ivg2
5|1132558|1|ivg2
6|1132642|1|ivg2
7|1132642|2|ivg4
8|1132642|3|ivg5
9|1132642|4|ivg7
10|1123291|1|ivg1

I hope this makes sense.

Thanks in advance for any help.

David

djfscouse,

Does it need to be a macro? In cell C2 and copied down:

Please Login or Register  to view this content.

Macro version:

Please Login or Register  to view this content.

You're very welcome