Find and count Duplicates

[flds]

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 Code and Number column is what I need to count.

Seq Code Number Result Count
1 V 1-32100-0001-01 3
2 V 1-32100-0001-01
3 V 1-32100-0001-01
4 STR 1-42210-0001-01 2
5 STR 1-42210-0001-01
6 STR 1-42210-0001-03 1
7 V 1-32710-0001-01 2
8 V 1-32710-0001-01
9 NV 1-32710-0001-01 2
10 NV 1-32710-0001-01
11 FE 1-33310-0001-01 2
12 FE 1-33310-0001-01
13 NV 1-33310-0001-01 1
14 NV 1-33310-0001-02 3
15 NV 1-33310-0001-02
16 NV 1-33310-0001-02

I need to know how many column B (codes) counts are in each (Column C)
number . I have similar numbers with different dulicated codes.

I hope this message is clear
Thanks
FLDS




I hope I have explained this in a correct manner.
I thank you in advance for your help.
FLDS

[Dunc3142]

Look at attached workbook.

[flds]

Thanks for your reply.

This is not what I want. The result should be

in the same row as follows,

on row 1 result should show 3 "V's" under 1-32100-0001-01,

row 4 result should show 2 "SRT's" under 1-42210-0001-01

row 5 result should show 1 "SRT" under 1-42210-0001-03

row 7 result should show 2 "V's" under 1-32710-0001-01

row 9 result should show 2 "NV's" under 1-32710-0001-01

row 11 result should show 2 "FE's" under 1-33310-0001-01

row 13 result should show 1 "NV" under 1-33310-0001-01

row 14 result should show 3 "NV's" under 1-33310-0001-02

The Nmber (column "C") becomes unique and it should show the cound of codes (column "B").

Sorry if my message was not understandable.

Thanks
FLDS