dispro
06-27-2014, 11:32 AM
Hello,
I struggled with this problem for a few days and would like to get some help.
I need to compare two versions of the same table when the differences are displayed in a new table.
Table 1 (old version) - sheet1:
PartNum
Location
CCN01905
J6
CCN01905
J100
CCN01905
J200
CCN01905
J300
CCN01905
J400
CCN04455
J800
CCN05363
J3
CCP01960
C1
CCP01960
C3
CCP01960
C5
CCP01960
C143
CCP01960
C147
CCP02583
C19
CCP02583
C20
Table 2 (new version) - sheet2:
PartNum
Location
CCN01905
J6
CCN01905
J201
CCN01905
J300
CCN01905
J400
CCN04455
J800
CCN05363
J3
CCP01960
C1
CCP01960
C3
CCP01960
C5
CCP01960
C143
CCP01960
C147
CCP02581
C19
CCP02581
C20
The table of differences should be created in sheet 3 and should include the following fields:
PartNum (Old)
PartNum (New)
Loacation (Old)
Loaction (New)
Additional table (in sheet3) should include a number of times each PartNum appears in both versions.
PartNum
Old Version
New Version
CCN01905
5
4
1. As you can see each Partnum can appear more then once in the table but in different locations.
2. The same PartNum (with the same location) could appear in different rows in both versions but it's don't mean that there was a difference between them.
Thanks!
I struggled with this problem for a few days and would like to get some help.
I need to compare two versions of the same table when the differences are displayed in a new table.
Table 1 (old version) - sheet1:
PartNum
Location
CCN01905
J6
CCN01905
J100
CCN01905
J200
CCN01905
J300
CCN01905
J400
CCN04455
J800
CCN05363
J3
CCP01960
C1
CCP01960
C3
CCP01960
C5
CCP01960
C143
CCP01960
C147
CCP02583
C19
CCP02583
C20
Table 2 (new version) - sheet2:
PartNum
Location
CCN01905
J6
CCN01905
J201
CCN01905
J300
CCN01905
J400
CCN04455
J800
CCN05363
J3
CCP01960
C1
CCP01960
C3
CCP01960
C5
CCP01960
C143
CCP01960
C147
CCP02581
C19
CCP02581
C20
The table of differences should be created in sheet 3 and should include the following fields:
PartNum (Old)
PartNum (New)
Loacation (Old)
Loaction (New)
Additional table (in sheet3) should include a number of times each PartNum appears in both versions.
PartNum
Old Version
New Version
CCN01905
5
4
1. As you can see each Partnum can appear more then once in the table but in different locations.
2. The same PartNum (with the same location) could appear in different rows in both versions but it's don't mean that there was a difference between them.
Thanks!