Team Trend Assistance

ibarajas 

I'm not certain about your sample data but it looks like your goal is to determine the most frequently occurring text item(s) by team -- essentially a Mode Text w/1 criteria.

This Lambda will do it:

Mode.Text = LAMBDA(crit_range, crit, texts,
        LET(
            include, FILTER(texts, crit_range = crit),
            occ, XMATCH(include, include),
            common, IFERROR(MODE.MULT(occ),0),
            SORT(XLOOKUP(common, occ, include, include))
        )
    )