Thank you for your time to view my question.
I have production data that will list component part #s as well as production part #in one column (Product Code in table below); in the adjacent column, the serial number of each component and production unit is listed (Barcode Serial Number). Whenever we replenish a box of components used in the production process, we scan a ticket with the part number but has a different serial number from box to box.
I am trying to devise a way to count the number of serial #s between the same component #s; here is a sample of my data. BTW, I've tried a pivot table but it gives only an average; I need count of serial numbers so that I can get a range of how many units are produced between boxes.
<tbody>
</tbody>I am working with several thousand lines of data; any and all help is greatly appreciated!
Thanks and always in search of my next cold one,
NearBeer
I have production data that will list component part #s as well as production part #in one column (Product Code in table below); in the adjacent column, the serial number of each component and production unit is listed (Barcode Serial Number). Whenever we replenish a box of components used in the production process, we scan a ticket with the part number but has a different serial number from box to box.
I am trying to devise a way to count the number of serial #s between the same component #s; here is a sample of my data. BTW, I've tried a pivot table but it gives only an average; I need count of serial numbers so that I can get a range of how many units are produced between boxes.
Scan Date | Operation Type | Product Code | Machine # | Workpost # | Barcode Serial Number |
09/19/2014 23:49 | CA | CARCJ80S2586 | S2 | F01 | 58625478 |
09/19/2014 23:49 | CA | CARCAF0T1658 | T1 | F01 | 65804077 |
09/19/2014 23:28 | CA | CARCAF0T1658 | T1 | F01 | 65804076 |
09/19/2014 23:29 | CA | CARCJ80S2586 | S2 | F01 | 58625477 |
09/19/2014 23:31 | <acronym title="Google Page Ranking">PR</acronym> | FECX187029 | S2 | FEX | 17092014-A85 |
… | … | … | … | … | … |
… | … | … | … | … | … |
09/19/2014 22:58 | CA | CARCAF0T1658 | T1 | F01 | 65804070 |
09/19/2014 16:29 | CA | CARC9L0S2688 | S2 | F01 | 68850901 |
09/19/2014 16:23 | CA | CARC9L0S2688 | S2 | F01 | 68850900 |
09/19/2014 16:20 | CA | CARCAF0T1658 | T1 | F01 | 65804012 |
09/19/2014 16:24 | <acronym title="Google Page Ranking">PR</acronym> | FECX166884 | S2 | FEX | 18092014-D14 |
<tbody>
</tbody>
Thanks and always in search of my next cold one,
NearBeer