Matching data in tables - Filtering

[Jo Davis]

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]

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

 

[Jo Davis]

Cheers Dave

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