Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart - Data Tables | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
Comparing data in tables | Excel Discussion (Misc queries) | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) |