Dave,
Sorry I should have been more specific. I am trying to match A1 with A1
and then if there is no match I want it to show all of the results in that
row (eg. A1 through A5). My end result would be any items that do not match
would be shown as exceptions and all the items that matched something do not
appear. Again I am trying to match specific cells but when there is an
exception I want to show the entire row.

Thanks,


"Dave Peterson" wrote:

Cell by cell?

A1 with A1, Q12 with Q12, AC232 with AC232?

If yes, then you could use a program written by Myrna Larson and Bill Manville.

You can find a copy on Chip Pearson's site:
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

Rich wrote:

Hello,
Does anyone know how I can compare two seperate tabs of data and show
only the exceptions on a seperate tab? I am comparing data on two tables and
only need to know which ones don't match.

Thanks,

--

Dave Peterson