suppose you have data in column C

first sort the Number.

In D2 put this formula and drag it till u have the data
=IF(C2=C1,"",COUNTIF(C:C,C2))




On Jun 19, 10:02*pm, flds wrote:
Hi Somebody,

I need your help with a formula or a vba code.

This is what I am trying to do.

I have a spreadsheet with 7000+ records with many columns filled. I am
trying to find repeats (duplicates) and count them and enter the count
in a new column, same row where the first unique occurrence appear.
I have about 320 codes and about 500+ numbers which need to be counted
at the moment I am doing it manually. The list is growing.

This is the example of the sheet with the result. The number column is
what I need to count.

Name * *Code * *Number * * * * * * * * * * * * * Result Count
A * * * V * * * * * * * 1-32100-0001-01 * * * * * * * * 3
A * * * V * * * * * * * 1-32100-0001-01
A * * * V * * * * * * * 1-32100-0001-01
B * * * STR * * 1-42210-0001-01 * * * * * * * * 1
B * * * STR * * 1-42210-0001-02 * * * * * * * * 1
B * * * STR * * 1-42210-0001-03 * * * * * * * * 1
C * * * V * * * * * * * 1-32710-0001-01 * * * * * * * * 2
C * * * V * * * * * * * 1-32710-0001-01
D * * * NV * * * * * * *1-32710-0001-01 * * * * * * * * 2
D * * * NV * * * * * * *1-32710-0001-01
E * * * FE * * * * * * *1-33310-0001-01 * * * * * * * * 2
E * * * FE * * * * * * *1-33310-0001-01
F * * * NV * * * * * * *1-33310-0001-02 * * * * * * * * 4
F * * * NV * * * * * * *1-33310-0001-02
F * * * NV * * * * * * *1-33310-0001-02
F * * * NV * * * * * * *1-33310-0001-02

I hope I have explained this in a correct manner.

I thank you in advance for your help.

FLDS