count duplicate consecutive, except special values

[fs993]

good morning every one

I had a worksheet include

A1 to AFM1 contain "DCO" & "CNX" & "OPS" & "ADD" & "MND"

I want to count how many "DCO" duplicate consecutively, ignoring if "ADD" is in between.

 

[fs993]

any idea please

 

[Aladin Akyurek]

Try to post an Excell readable small sample along with the desired result.

 

[fs993]

 

[Aladin Akyurek]

I'm afraid that requires retyping. Try to post rather using one of the methods listed in: Attachments.

 

[fs993]

sorry
the results should be
student1: 2
student2: 0
student3: 1

 

[fs993]

any idea

 

[fs993]

any idea

 

[Aladin Akyurek]

any idea

Hope you are not waiting for someone to re-type your image into Excel and develop the formula on the retyped data...