I have two columns. Column K has a bunch of values, Column L has some of these values. I want to filter everything that appears in Column L out of Column K. How would I do this?
The possible solution to calculate intersection of Column K and Column L is:
=FILTER(UNIQUE(K2:K), (ARRAYFORMULA( COUNTIF(UNIQUE(L2:L), ARRAYFORMULA( UNIQUE(K2:K) ))))>0)
Please, see prepared example here: Columns Intersection