Find and count Duplicates (occurrences)

[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 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

 

[muddan madhu]

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))

 

[flds]

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))











- Show quoted text -

Thank you Muddan Madhu, you were truely fast in your reply I
appreciate it very much.

It is not only the (C column) Number that I need to count, 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
might have not been clear in my message.

When I drag down the formula you sent it counts all the "V's" in
column B (code) gives me a count of 5 and "NV's" a count of 6.

I hope I am clear this time.

Thanks

FLDS