if in column a does not exist copy b to c

Hi,

Need help again and now I am sure this is the place to be:

2 columns A and B

I need column C created with only the unique values from B that don't exist in A.

hope it makes sense

also I want to mention that they are not equal...

one is 20.000 and the other 30.000 entries

=IFERROR(VLOOKUP(B1,A:A,1,0),B1)

try pasting this into C1 then copy down.

other wise please paste a sample spreadsheet, removing any sensitive data first

yep, it did not work, let me send a pic

excel-help.jpg

I just need the unique entries from B copied to C

you'll need to copy the formula down all the cells, its works but not how you want it to i dont think

See the attached

mama really knows... but I an not even clever enough to copy/implement your formula...

=IFERROR(INDEX(B$2:B$6,MATCH(,IF(ISNA(MATCH(B$2:B$6,A$2:A$5,)),COUNTIF(C$1:C1,B$2:B$6)),)),"")

can you do a step by step maybe

1. Copy this to...
2. drag to fill everything...

not sure

move your mouse to lower right of c2 until it turns to skinny cross, hold your left click and drag it down as far as needed