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
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
excel-help.jpg
I just need the unique entries from B copied to C
yep, it did not work, let me send a pic
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
can you do a step by step maybe
1. Copy this to...
2. drag to fill everything...
not sure
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)),)),"")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks