Excel Two Columns With Duplicates
excel
Solution
In cell C1 use this formula:
=IF(VLOOKUP(B1,A:A,1)=B1,"",B1)
Copy and paste it to all rows that have a value in column B and it will show the unique values.
Then copy column C to column D by Paste Values so that you can sort it / filter out blanks.
Problem
So I have two columns in excel with column A containing nearly the exact same data as column B. I need a way to Match column A with Column B and any values that are the same in Column A and Column B need to be removed from Column B. So Column A has 11,592 product SKU numbers. Column B has 12,555 product SKU numbers. And I need a way to get the SKU product numbers from Column B that are not in Column A. Maybe put them into Column C?