Hello,
I try to tackle following challange:
I have an external list with a kind of "projects", where I asks different people for feedback.
In column "B" I have these people listed, and in column "C" I can see, from whom I got Feedback.
Now I need to figure out them, who are missing.
So in 5 of my 6 projects in total 10 missing feedback.
So the ideal result would look like this.
Until now I was only able, to split the origin column "B" into results and sort them into new lines.
But now I have no idea, how to proceed, and remove only them from my modified column "B", who is already listed in column "C"
In the attached file I split the query into two: one for contacts and one for feedback. Then I merged them keeping only nulls. See query in file called 'Merge1' on the Trial sheet. Hope that's what you wanted.
Mynda
Hello Treacy,
thanks you very much for that, it woks great 🙂