filter items from 2 columns

Hi, I would like to ask someone more experienced to help me with this problem:

I have 2 columns (A & B)

in the A column there is a list of e-mail adresses of subscribers, in the second column there is a list of email adresses of the people who decided to delete their subscription.

I would like to filter the columns, so in the "C" column there will be the list of subscribers from the column A without the people (emails in the B column) who decided to unsubscribe.

Is there any simple way how to achieve that? Thank you. Any help will be appreciated.

Try...
=if(and(istext(a1),isblank(b1)),a1,"")

That will only give you those addresses in column A.

Hope this helps.

-Z

Originally Posted by Zodeeak

Try...
=if(and(istext(a1),isblank(b1)),a1,"")

That will only give you those addresses in column A.

Hope this helps.

-Z

Hi, thank you for your response. Unfortunately it doesn't work as I would like to. It shows the A column items only when the item next to it in the B column is empty. Basically what I need is some kind of formula that takes for example A1 and checks if the whole column B contains a cell with same text - if not -> list the value(text) in the C column ... if yes - skip the item and go to the next one. Ideally in the column C, there would be list of adresses (without gaps between them) that are present in the A column and not in the B column.

Originally Posted by nflsales

attach sample file with expected results

Ok, here you go.

samplex3333.xlsx

Originally Posted by nflsales

=IFERROR(VLOOKUP(B3,A$3:A$60,1,0),"")
try this in C3 and copy towards down

that doesn't work

Originally Posted by alansidman

Try this: =IF(ISERROR(VLOOKUP(A2,$B$2:$B$3,1,FALSE)),A2,"") and copy down

Yeah that works great thank you. Is there any simple way how to get rid of the blank cells in the C column? I have aproximately 20K subscribers and about 200 unsubscribed, so now there are 200 blank spots spread throughout the C column

Thank you .