Compare two columns: return in a third column what is in B but not in A

Question:

( by Naast )

Hello everyone, this is my first question here.

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. 

I have next to no knowledge of spreadsheets, but I'd really like to learn more.

Solution:

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.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive