Forum Discussion
|| Challenge for Team ||
Dear Team This mail is offering a challenge to your team; So, the challenge is: - Suppose an Employee Muster Roll (A sheet that shows employee status daily wise whether he/she is present or not) ...
You could use BYROW:
=LET(
ten_consecutive, REPT("PP", 10),
check, LAMBDA(each_row,
LET(
joined, CONCAT(each_row),
streak, XMATCH("*" & ten_consecutive & "*", joined, 2),
IF(ISNUMBER(streak), "Yes", "No")
)
),
BYROW(schedule, check)
)
