TEXTJOIN() with ()*()*() for AND() Logic Not Working as Expected
I have four criteria. When I use Text join with all four criteria, I get no matches; however, when I do it separately, I get matches for all four and common values across all four results. I need a list with just these common values. This is “AND()” logic.