Finding 2 out of 3 consecutive equal cell values

Hi Everyone ,


I would really appreciate some assistance with the following scenario.


Say I have Column A populated with Employee Names, and Column B populated with "Pass" or "Fail" (which indicates a passed or failed customer service call monitoring).


For each employee, I want to be able to look at all of their overall scores (usually between 3 and 10 evaluations per month) and easily highlight people who have failed 2 out of 3 consecutive evaluations.


I want to integrate this feature in to a weekly quality report and would be grateful for any input and ideas you may have. Please let me know if I have not explained myself clearly and you require more information.


Kind regards,
James

Hi,

Can u please provide Excel Sample for the same.

Regards

Santosh