Matching data in tables - Filtering

I have two tables of data, some of the rows are duplicated in these tables i
want to find the data that is different.

will an advanced filter do this?

Chip Pearson has lots of info about working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

Jo Davis wrote:
>
> I have two tables of data, some of the rows are duplicated in these tables i
> want to find the data that is different.
>
> will an advanced filter do this?

--

Dave Peterson

Cheers Dave

"Dave Peterson" wrote:

> Chip Pearson has lots of info about working with duplicates at:
> http://www.cpearson.com/excel/duplicat.htm
>
> Jo Davis wrote:
> >
> > I have two tables of data, some of the rows are duplicated in these tables i
> > want to find the data that is different.
> >
> > will an advanced filter do this?
>
> --
>
> Dave Peterson
>