Match / Compare problem

[imported_unknown]

I have two spreadsheets that has two similar listing. Both sheets will have information that is the same, however, both will have differences too. I want to compare the lists and create a list of the items that match. I also want of whatever is left over from the list. Can someone provide me with a solution? Many Thanks

 

[PaddyD]

hi - welcome to the board!

couple of options here:

http://216.92.17.166/board/viewtopic.php?topic=23775&forum=2

(thre ara many more if you don't like either of them...)

post back with results / more info etc if you need to ...

paddy