comparing 2 worksheets that are in a table format

[mdb666]

I have 2 worksheets inside of a spreadsheet file. I would like to know what "records" or "rows" from the one worksheet exist in the other worksheet. In other words, in a 3rd worksheet I would like all of the rows that are identical from the initial 2 worksheets. I would also like to be able to specify what columns I will be doing the comparison on.

I beleive this would be similar to a crosstab in a database application. Anybody have any suggestions on how I can accomplish this in Excel?

 

[kieran]

You could try using MSQuery with each worksheet defined as a table.

A crosstab query will then give you the answers you want.

If you are unfamiliar with MSQuery, post back, there are a few experts around here I think.

 

[mdb666]

Thank You for the response. No, I am not familiar with MSQUERY. Is this something that is an add-on product or does it come with MS Office?

 

[kieran]

Sorry for the delay in reply.

It is usually available with all versions of office.

To check go to (in excel) data, get external data, create new query.

Choose MS excel as the data source.

If yo are familiar with MS Access the query form should be easy enough to use.

HIH

 

[mdb666]

Thank You