Forum Discussion
Solved
Filter with dynamic list as an condition.
Hi, My goal here is to find which tables a name is in, and then which they are not in. It lists perfect if the name is in 1 tabler, or in all 3. But not if the name is in 2 tables. All 3...
I've modified the existing formula slightly.
=LET(arrange,UNIQUE((CHOOSECOLS(B14#,2))),FILTER(arrange,ISERROR(XMATCH(arrange,L6#)),"Alle"))
The issue with the previous arrangement was when the number of elements being compared was not the same. The array with fewer elements threw an #N/A.
You're welcome! Glad to help.