How to match and compare two spreadsheets

[Guest]

I have two tables of data each with one common key. I'd like an excel
function that can bring both tables together by matching the key column and
identify items on each of the tables that have no match so no data is lost.

NB- the common key can be numeric or alhp-numeric.

 

[ajetrumpet]

Excel has keys? Maybe I should know that...if I don't, maybe I should be embarrased?

First thing I thought of was to export these two sheets into Access and perform a UNION ALL query. Are you familiar with Access?
I know you can do what you're saying in Excel by writing some VBA in a module, but I am not an expert on code writing, sorry....

 

[Guest]

See here:

http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon