Question posted 2012 · +7 upvotes
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?
Accepted answer +7 upvotes
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.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.