Hello.
I use this formula to count unique text in a column and it works well:
=ArrayFormula(SUM(IF(FREQUENCY(IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""), IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""))>0,1))) resulting in 6.
But the cells in the column also contain the word "Sea" or "Freedom" followed by a...