comparing 2 worksheets that are in a table format

M

mdb666

New Member
Joined
May 14, 2003
Messages
6
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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
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.
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Excel VBA: Form to be filled in with data from another worksheet
2
Replies
15
Views
348
MikeVol
MikeVol
B
  • Solved
OPTIMIZE my code
Replies
5
Views
262
BritsBlitz
B
M
  • Solved
VBA to Insert Mismatched Row in separate worksheet
2 3
Replies
21
Views
526
Peter_SSs
Peter_SSs
N
  • Question
Finding the differences then copy and paste code to a new sheet
Replies
1
Views
484
myall_blues
myall_blues
J
  • Question
Compare 2 Workbooks and add only the New Information to a Master Sheet
Replies
0
Views
233
jpaul123
J

Forum statistics

Threads
1,221,691
Messages
6,161,322
Members
451,696
Latest member
Senthil Murugan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top