If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Frequency of Serial Number
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 |
#2
|
|||
|
|||
Frequency of Serial Number
On Sep 18, 11:17 am, Andri wrote:
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 =COUNTIF(Sheet1!B:B,"76-1031")&".76-1031" |
Thread Tools | |
Display Modes | |
|
|