Snasui Excel Forum • consecutive count

Page 1 of 1

consecutive count

Posted: Sat Jan 29, 2022 9:35 pm

by sna

Hi there,
I need your help for formula If 5 Times "Yes" then TRUE otherwise Empty
I attach a sample template

TY

Re: consecutive count

Posted: Sat Jan 29, 2022 9:54 pm

by norkaz

...

B6

=IF(AND(INDEX(INDIRECT("A"&ROWS($B$6:B7)&":"&"A"&ROWS($B$6:B11))="YES",0)),"TRUE","")

Norkaz

Re: consecutive count

Posted: Sun Jan 30, 2022 4:23 pm

by logic

Another,

B2 =IFERROR(IF(COUNTIFS(OFFSET(A2,0,0,-5,1),"Yes")=5,TRUE,""),"")

Re: consecutive count

Posted: Mon Jan 31, 2022 2:40 pm

by sna

Thank you both