ExcelBanter - Matching data in tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matching data in tables - Filtering (https://www.excelbanter.com/excel-discussion-misc-queries/47494-matching-data-tables-filtering.html)

Jo Davis

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?

Dave Peterson

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

Jo Davis

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

All times are GMT +1. The time now is 06:03 PM.