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

How to do comparison among 8 columns of data with one another? I have to compare every column with every other column. Also i need to know : what is missing in one column and present in another and vice versa.

share|improve this question
What kind of comparison? What does your data look like? We really need a lot more information. – Dennis Williamson Sep 23 '10 at 11:26

If you're using Excel or some spreadsheet, sort the items in the same order and use your eyes. If an item doesn't exist in a column, add a blank entry to the others to keep everything lined up. It's slow and a pain, but it works.

Sort each column of data in the same order, then extract each to a separate file in Excel or a text file, or some common format. Use an application such as BeyondCompare to compare two files at a time. It will show mismatches between the two. I don't think it can do more than two at a time, however. It's not slow and usually works very nicely.

share|improve this answer

You must log in to answer this question.

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