ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   compare data from two tables with varying record numbers (https://www.excelbanter.com/excel-worksheet-functions/175044-compare-data-two-tables-varying-record-numbers.html)

british521

compare data from two tables with varying record numbers
 
I have two tables with similar information. On both tables, column "A" is a
list of assets and column "C" is a list of parts associated with the assets.
Although the assets are the same, the number of parts per asset are different
on each table. I need to identify the differences between the two tables.
How can I compare (identify the mis-matches) the data in these tables?

Thanks for your help!


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com