How to return a join without a specific value?
Hi guys, been racking my brain all morning on this one. I have a column with an array of names, and another column with singular names. I'm looking to compare the 2 columns, remove the matching name, then return the remaining names.
My full formula will contain matching on multiple criteria, the name matching as described above and if 2 date values match. I got these working independently, just can't quite wrap my head around the removal of the matched value and returning the remainder.
Help Article Resources
Check out the Formula Handbook template!