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