Find and count Duplicates (occurrences)
 

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

Find and count Duplicates (occurrences)
 

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

Find and count Duplicates (occurrences)
 

On Jun 19, 1:40*pm, muddan madhu wrote:
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- Hide quoted text -

- 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