HELP NEEDED! Formula needed for word matches in three different columns

melissach 

There are some details that I don't know, but I will create this demo going by these rules:

-Excel 365

-a given word must appear at least 3 times in a given row

-exact matches on words, no partials

=LET(
    target, 3,
    cols, COLUMNS(matrix),
    multiplier, SEQUENCE(cols, , 1, 0),
    BYROW(
        colors,
        LAMBDA(each_color,
            LET(
                vector, MMULT(N(matrix = each_color), multiplier),
                SUM(N(vector >= target))
            )
        )
    )
)