Spreadsheet: 209917d1359302213-sort-and-compare-multiple-database-outputs-identifying-variances-database-validation
Sheet: Sheet1

Database 1 |  |  |  |  | Database 2
[NAME] | Product code | Quantity | Value |  | [NAME] | Product code | Quantity | Value
19646 | 510 | 31175.233 | 419378.5868859 |  | 217638 | 544 | 6931.58 | 100717.94
24836 | 524 | 545.146 | 6964.0766062 |  | 210138 | 524 | 3104.528 | 39659.41
24836 | 524 | 519.163 | 6632.1515761 |  | 177683 | 594 | 16845.817 | 126031.98
64352 | 541 | 105.128 | 1101.8781064 |  | 19646 | 510 | 31175.233 | 419378.59
64352 | 574 | 1267.179 | 14903.7990906 |  | 64352 | 574 | 1267.179 | 14903.8
65078 | 504 | 27938.829 | 248351.0448639 |  | 24836 | 524 | 545.146 | 6964.08
65078 | 524 | 66917.744 | 854854.1042768 |  | 65078 | 594 | 30007.894 | 224504.06
65078 | 594 | 30007.894 | 224504.058961 |  | 218974 | 594 | 11830.733 | 88511.63
162628 | 594 | 18754.675 | 140313.1010125 |  | 217638 | 504 | 12410.105 | 110314.66
163964 | 524 | 10248.632 | 130923.1992104 |  | 65078 | 504 | 27938.829 | 248351.04
177683 | 594 | 16845.817 | 126031.9798855 |  | 162628 | 594 | 53766.273 | 402252.37
198325 | 594 | 87960.95 | 658079.847425 |  | 198325 | 594 | 87960.95 | 658079.85
210138 | 514 | 1948.81 | 26004.335997 |  | 217638 | 524 | 5117.759 | 65377.84
210138 | 524 | 3104.528 | 39659.4138416 |  | 64352 | 541 | 105.128 | 1101.88
217638 | 504 | 12428.01 | 110473.823691 |  | 210138 | 514 | 1948.81 | 26004.34
217638 | 524 | 4877.204 | 62304.8179388 |  | 65078 | 524 | 66917.744 | 854854.1
217638 | 544 | 6942.682 | 100879.2522646 |  | 163964 | 524 | 10248.632 | 130923.2
218974 | 594 | 11830.733 | 88511.6289395
Final Out Put Requered
Database 1 |  |  |  |  | Database 2
[NAME] | Product code | Quantity | Value |  | [NAME] | Product code | Quantity | Value | Column1
19646 | 510 | 31175.233 | 419378.5868859 |  | 19646 | 510 | 31175.233 | 419378.59
24836 | 524 | 545.146 | 6964.0766062 |  | 24836 | 524 | 545.146 | 6964.08
24836 | 524 | 519.163 | 6632.1515761 |  |  |  |  |  | [NAME] row for missing item
64352 | 541 | 105.128 | 1101.8781064 |  | 64352 | 541 | 105.128 | 1101.88
64352 | 574 | 1267.179 | 14903.7990906 |  | 64352 | 574 | 1267.179 | 14903.8
65078 | 504 | 27938.829 | 248351.0448639 |  | 65078 | 504 | 27938.829 | 248351.04
65078 | 524 | 66917.744 | 854854.1042768 |  | 65078 | 524 | 66917.744 | 854854.1
65078 | 594 | 30007.894 | 224504.058961 |  | 65078 | 594 | 30007.894 | 224504.06
162628 | 594 | 18754.675 | 140313.1010125 |  | 162628 | 594 | 53766.273 | 402252.37 | Highlight varience
163964 | 524 | 10248.632 | 130923.1992104 |  | 163964 | 524 | 10248.632 | 130923.2
177683 | 594 | 16845.817 | 126031.9798855 |  | 177683 | 594 | 16845.817 | 126031.98
198325 | 594 | 87960.95 | 658079.847425 |  | 198325 | 594 | 87960.95 | 658079.85
210138 | 514 | 1948.81 | 26004.335997 |  | 210138 | 514 | 1948.81 | 26004.34
210138 | 524 | 3104.528 | 39659.4138416 |  | 210138 | 524 | 3104.528 | 39659.41
217638 | 504 | 12428.01 | 110473.823691 |  | 217638 | 504 | 12410.105 | 110314.66 | Highlight varience
217638 | 524 | 4877.204 | 62304.8179388 |  | 217638 | 524 | 5117.759 | 65377.84 | Highlight varience
217638 | 544 | 6942.682 | 100879.2522646 |  | 217638 | 544 | 6931.58 | 100717.94 | Highlight varience
218974 | 594 | 11830.733 | 88511.6289395 |  | 218974 | 594 | 11830.733 | 88511.63