Excel can be used to combine and compare data from 2 different spreadsheets.
The example below shows how this can be done even if the primary key columns contain different data.
| Data Set 1 | Data Set 2 | |||
| 100-A | 10 | 100-A | 3 | |
| 100-B | 7 | 100-C | 1 | |
| 100-C | 8 | 100-D | 20 | |
| Master List and Result | ||||
| Set 1 | Set 2 | TOTAL | ||
| 100-A | 10 | 3 | 13 | |
| 100-B | 7 | 0 | 7 | |
| 100-C | 8 | 1 | 9 | |
| 100-D | 0 | 20 | 20 | |
Copyright © AS Systems, All Rights Reserved | WordPress Development by WEBDOGS