( by Naast )
It's exactly what the title says. I have this document and I'm trying to make a list of characters that are in B but not in A.
Have a look at the following screenshot:
Put the following formula in Cell C3:
=query(arrayformula(iferror(if(match(B:B;A:A;0)>0;"");B:B));"select Col1 where Col1<>'' order by Col1")
And make sure that you don't have extra spaces in any of your cells, that is there should not be any cell having extra white space at the beginning or at the end of the text.
Or else try the following formula:
=query(arrayformula(iferror(if(match(trim(B:B);trim(A:A);0)>0;"");trim(B:B)));"select Col1 where Col1<>'' order by Col1")
Above formula has trim function which will take care of the extra spaces of the contents of all cells.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.