Thank you for taking the time to look at my question.
I have a production query that returns several columns of production data; see the example below:
<tbody>
</tbody>
What I need to do is count the number of “Barcode Serial Numbers” between “Workpost #” on the same machine; IOTW, for S2 (Machine # column) I need to count the number of products that start with “CARC….” from the Product Code column which occur between “FEX” in the “Workpost #” for the same machine.
What makes this a bit complicated is that there are multiple values for each workpost (not just F01 & FEX). I need to be able to figure out for each machine number, how many “CARC” were made in between “FEX”; in this case it is (2)…I have deleted a number of rows to clean up the sheet a bit.
Again, I appreciate your help!
I have a production query that returns several columns of production data; see the example below:
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 | PR | 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 | PR | FECX166884 | S2 | FEX | 18092014-D14 |
<tbody>
</tbody>
What I need to do is count the number of “Barcode Serial Numbers” between “Workpost #” on the same machine; IOTW, for S2 (Machine # column) I need to count the number of products that start with “CARC….” from the Product Code column which occur between “FEX” in the “Workpost #” for the same machine.
What makes this a bit complicated is that there are multiple values for each workpost (not just F01 & FEX). I need to be able to figure out for each machine number, how many “CARC” were made in between “FEX”; in this case it is (2)…I have deleted a number of rows to clean up the sheet a bit.
Again, I appreciate your help!
Last edited: