Formula to count a value appearing consecutively 2 or more times in multiple columns

Question

Hi There,&nbsp;I am looking for a formula, basically to count a string value appearing consecutively for 2 or more times in multiple columns. Have got an idea, however not sure about the implementation part. I have manually done it below, but a formula would really help a lot.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Consecutive Pass&nbsp;Day1Day2Day3Day4Day5Day6&nbsp;oncetwicethriceCase1PassFailPassFailPassPass&nbsp;Yes&nbsp;&nbsp;Case2PassPassFailPassPassPass&nbsp;YesYes&nbsp;Case3FailPassPassPassPassFail&nbsp;YesYesYesCase4PassFailPassPassPassPass&nbsp;YesYesYesCase5PassPassFailPassPassPass&nbsp;YesYes&nbsp;Case6PassPassPassPassPassPass&nbsp;YesYesYesCase7PassPassPassFailPassPass&nbsp;YesYes&nbsp;Case8PassPassFailPassPassPass&nbsp;YesYes&nbsp;Case9PassFailPassPassPassPass&nbsp;YesYesYesCase10PassPassPassFailPassPass&nbsp;YesYes&nbsp;&nbsp;Any help on this front would be really appreciated. Please do let me know if any more details required.&nbsp;Thanks&nbsp;Mohsin&nbsp;

Forum Discussion

Formula to count a value appearing consecutively 2 or more times in multiple columns

1 Reply

Resources

							Consecutive Pass
	Day1	Day2	Day3	Day4	Day5	Day6	once	twice	thrice
Case1	Pass	Fail	Pass	Fail	Pass	Pass	Yes
Case2	Pass	Pass	Fail	Pass	Pass	Pass	Yes	Yes
Case3	Fail	Pass	Pass	Pass	Pass	Fail	Yes	Yes	Yes
Case4	Pass	Fail	Pass	Pass	Pass	Pass	Yes	Yes	Yes
Case5	Pass	Pass	Fail	Pass	Pass	Pass	Yes	Yes
Case6	Pass	Pass	Pass	Pass	Pass	Pass	Yes	Yes	Yes
Case7	Pass	Pass	Pass	Fail	Pass	Pass	Yes	Yes
Case8	Pass	Pass	Fail	Pass	Pass	Pass	Yes	Yes
Case9	Pass	Fail	Pass	Pass	Pass	Pass	Yes	Yes	Yes
Case10	Pass	Pass	Pass	Fail	Pass	Pass	Yes	Yes