How many values between other values (count number cells between two of the same text)

[nearbeer]

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>
[TD="class: xl65, align: center"] Scan Date
[/TD]
[TD="class: xl65, width: 104, align: center"] Operation Type [/TD]
[TD="class: xl65, width: 99, align: center"] Product Code [/TD]
[TD="class: xl65, width: 71, align: center"] Machine # [/TD]
[TD="class: xl65, width: 78, align: center"] Workpost # [/TD]
[TD="class: xl65, width: 152, align: center"] Barcode Serial Number [/TD]

[TD="class: xl66, align: center"]09/19/2014 23:49[/TD]
[TD="class: xl67, align: center"]CA[/TD]
[TD="class: xl67, align: center"]CARCJ80S2586[/TD]
[TD="class: xl67, align: center"]S2[/TD]
[TD="class: xl67, align: center"]F01[/TD]
[TD="class: xl67, align: center"]58625478[/TD]

[TD="class: xl68, align: center"]09/19/2014 23:49[/TD]
[TD="class: xl69, align: center"]CA[/TD]
[TD="class: xl69, align: center"]CARCAF0T1658[/TD]
[TD="class: xl69, align: center"]T1[/TD]
[TD="class: xl69, align: center"]F01[/TD]
[TD="class: xl69, align: center"]65804077[/TD]

[TD="class: xl66, align: center"]09/19/2014 23:28[/TD]
[TD="class: xl67, align: center"]CA[/TD]
[TD="class: xl67, align: center"]CARCAF0T1658[/TD]
[TD="class: xl67, align: center"]T1[/TD]
[TD="class: xl67, align: center"]F01[/TD]
[TD="class: xl67, align: center"]65804076[/TD]

[TD="class: xl68, align: center"]09/19/2014 23:29[/TD]
[TD="class: xl69, align: center"]CA[/TD]
[TD="class: xl69, align: center"]CARCJ80S2586[/TD]
[TD="class: xl69, align: center"]S2[/TD]
[TD="class: xl69, align: center"]F01[/TD]
[TD="class: xl69, align: center"]58625477[/TD]

[TD="class: xl66, align: center"]09/19/2014 23:31[/TD]
[TD="class: xl67, align: center"]PR[/TD]
[TD="class: xl67, align: center"]FECX187029[/TD]
[TD="class: xl67, align: center"]S2[/TD]
[TD="class: xl67, align: center"]FEX[/TD]
[TD="class: xl67, align: center"]17092014-A85[/TD]

[TD="class: xl70, align: center"]…[/TD]
[TD="class: xl71, align: center"]…[/TD]
[TD="class: xl71, align: center"]…[/TD]
[TD="class: xl71, align: center"]…[/TD]
[TD="class: xl71, align: center"]…[/TD]
[TD="class: xl71, align: center"]…[/TD]

[TD="class: xl72, align: center"]…[/TD]
[TD="class: xl73, align: center"]…[/TD]
[TD="class: xl73, align: center"]…[/TD]
[TD="class: xl73, align: center"]…[/TD]
[TD="class: xl73, align: center"]…[/TD]
[TD="class: xl73, align: center"]…[/TD]

[TD="class: xl66, align: center"]09/19/2014 22:58[/TD]
[TD="class: xl67, align: center"]CA[/TD]
[TD="class: xl67, align: center"]CARCAF0T1658[/TD]
[TD="class: xl67, align: center"]T1[/TD]
[TD="class: xl67, align: center"]F01[/TD]
[TD="class: xl67, align: center"]65804070[/TD]

[TD="class: xl68, align: center"]09/19/2014 16:29[/TD]
[TD="class: xl69, align: center"]CA[/TD]
[TD="class: xl69, align: center"]CARC9L0S2688[/TD]
[TD="class: xl69, align: center"]S2[/TD]
[TD="class: xl69, align: center"]F01[/TD]
[TD="class: xl69, align: center"]68850901[/TD]

[TD="class: xl66, align: center"]09/19/2014 16:23[/TD]
[TD="class: xl67, align: center"]CA[/TD]
[TD="class: xl67, align: center"]CARC9L0S2688[/TD]
[TD="class: xl67, align: center"]S2[/TD]
[TD="class: xl67, align: center"]F01[/TD]
[TD="class: xl67, align: center"]68850900[/TD]

[TD="class: xl68, align: center"]09/19/2014 16:20[/TD]
[TD="class: xl69, align: center"]CA[/TD]
[TD="class: xl69, align: center"]CARCAF0T1658[/TD]
[TD="class: xl69, align: center"]T1[/TD]
[TD="class: xl69, align: center"]F01[/TD]
[TD="class: xl69, align: center"]65804012[/TD]

[TD="class: xl66, align: center"]09/19/2014 16:24[/TD]
[TD="class: xl67, align: center"]PR[/TD]
[TD="class: xl67, align: center"]FECX166884[/TD]
[TD="class: xl67, align: center"]S2[/TD]
[TD="class: xl67, align: center"]FEX[/TD]
[TD="class: xl67, align: center"]18092014-D14[/TD]

</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!