For a school play doc, I have a column with students’ names and another with the roles they are assigned.
In another table, I have listed the scenes and lookup columns that show which characters and corresponding actors are in that scene. I want the next column to show me who is NOT in that scene – show me all names except for the ones in the previous column. How would I do that?