Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

up vote 4 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
    
THANK YOU!!!!!!!!!! –  Ryan E Mar 7 at 0:28

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.