Excel Automation 1

"Retrieve the attendance code ‘M’ for a student over three or more consecutive days. For instance, if P or R line items in attendance code, Skip it and continue logic
For example,
image
Expected output
image

Hi sunil3,
Please check this project.

Demo.zip (9.5 KB)

Hope it helps you!

Hi @jose.ordonez1 ,Thanks for your swift response. I’m looking for a solution where consecutive attendance = M for 3 or more times and it should break the chain if it has attendance other than P,K.

Dear,
Please find the attached workflow. Before write line, you can print outputDt in excel using write range activity.
forum.zip (3.9 KB)

Input Data table I used:-

Output :-