Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 CSV documents. one has 10.000 rows with 50 columns, first row is a unique SKU. Now I have a second document with 9.500 rows using the same identifiers. I simply want to create a third document with the 500 missing records. Is this possible with excel?

share|improve this question
up vote 13 down vote accepted
  1. First copy the second CSV (with 9500 rows) in a blank spreadsheet.
  2. Give a background color (say yellow) to the cells having content.
  3. Now copy the first CSV into the spreadsheet appending it to the bottom of the first CSV
  4. Use 'Remove Duplicates' (in 2007 you can find it in Data tab) feature on the entire spreadsheet.
  5. After remove duplicates has completed, cells not having the background color given in step (2) found at the bottom of the spreadsheet are the missing records
share|improve this answer

I've used Beyond Compare by Scooter Software to do something similar. Don't know if it is supported by Excel directly.

Beyond Compare is one of my favorite pieces of software. It is so useful.

share|improve this answer
Thanks for the suggestion, the software looks useful, for this simple task though I prefer the ecel only solution. – Moak Jun 30 '12 at 8:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .