Frequency of Serial Number

A

Andri

Dear All,

Please help. I have the database as the following:
PartNumber SerialNumber
2117180-2 17-1162
2117180-2 109-136
2117180-2 24-629
2117180-2 108-1712
2117180-2 108-1702
2117180-2 36-955
2117180-2 36-955
2117180-2 76-1031
2117180-2 76-1031
2117180-2 58-1447
2117180-2 27-1192
2117180-2 95-870
2117180-2 76-1031
2117180-2 76-1031
2117180-2 40-2008
2117180-2 36-955

I would like to summary at other sheet:
Col A = Part Number
Col B = X.SN, Y.SN, Z.SN, etc = X, Y and Z is the frequency, SN = Serial
Number.
4.76-1031, 2.36-955, ...

Thank you for your kind attention and help.

Respectfully,
andri
 
S

Spiky

Dear All,

Please help. I have the database as the following:
PartNumber SerialNumber
2117180-2 17-1162
2117180-2 109-136
2117180-2 24-629
2117180-2 108-1712
2117180-2 108-1702
2117180-2 36-955
2117180-2 36-955
2117180-2 76-1031
2117180-2 76-1031
2117180-2 58-1447
2117180-2 27-1192
2117180-2 95-870
2117180-2 76-1031
2117180-2 76-1031
2117180-2 40-2008
2117180-2 36-955

I would like to summary at other sheet:
Col A = Part Number
Col B = X.SN, Y.SN, Z.SN, etc = X, Y and Z is the frequency, SN = Serial
Number.
4.76-1031, 2.36-955, ...

Thank you for your kind attention and help.

Respectfully,
andri
Click to expand...

=COUNTIF(Sheet1!B:B,"76-1031")&".76-1031"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with this challenging VBA coding 3
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0
Dump of perfection Test 1

Top