Spreadsheet: 179963d1347440678-match-a-postive-with-a-negative-in-a-column-and-remove-those-rows-example-1-
Sheet: 1615 Cost Transaction Drilldown

P/O Number | G/L Date | Hours / Litres | Amount | Status
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96 | Keep
85074642 | 2012-08-30 00:00:00 | -1 | -72.5 | Remove
85074646 | 2012-08-31 00:00:00 | -4.5 | -427.5 | Keep
85074655 | 2012-08-30 00:00:00 | -6 | -351 | Remove
85074658 | 2012-08-30 00:00:00 | -3 | -188.85 | Remove
85074662 |  | -24.5 | -1433.25 | Remove
85074663 | 2012-08-30 00:00:00 | -5 | -314.75 | Keep
85074664 | 2012-08-30 00:00:00 | -6 | -377.7 | Remove
85074666 | 2012-08-30 00:00:00 | -4 | -251.8 | Keep
85074667 | 2012-08-30 00:00:00 | -4 | -251.8 | Keep
85075950 | 2012-08-30 00:00:00 | -2 | -151.84 | Keep
85076744 |  | -32 | -2014.4 | Keep
85076745 |  | -45.5 | -2864.23 | Keep
85076746 |  | -27 | -1699.66 | Keep
85076747 |  | -38.5 | -2252.25 | Remove
85076748 |  | -36 | -2106 | Remove
85076749 |  | -14 | -1120 | Remove
85076750 |  | -36.5 | -2297.69 | Keep
85076751 |  | -41.5 | -2612.45 | Keep
85076752 |  | -28 | -2128 | Keep
85076753 |  | -40.5 | -2369.25 | Remove
85076755 | 2012-09-06 00:00:00 | -2 | -145 | Remove
85076756 |  | -17 | -1290.64 | Keep
85076759 |  | -8.5 | -645.32 | Keep
85076776 |  | -17 | -1615 | Keep
85076778 |  | -31 | -2945 | Keep
85074642 | 2012-08-31 00:00:00 | -3 | -217.5 | Remove
85074646 |  | -16.5 | -1567.5 | Keep
85074651 | 2012-08-30 00:00:00 | -14.5 | -1377.5 | Remove
85074662 | 2012-09-11 00:00:00 | -1 | -58.5 | Remove
85075950 | 2012-08-30 00:00:00 | -6 | -455.52 | Keep
85075951 | 2012-08-30 00:00:00 | -10.5 | -797.16 | Keep
85076744 | 2012-09-11 00:00:00 | -1 | -62.95 | Keep
85076746 | 2012-09-11 00:00:00 | -1 | -62.95 | Keep
85076747 | 2012-09-11 00:00:00 | -1 | -58.5 | Remove
85076753 | 2012-09-11 00:00:00 | -1 | -58.5 | Remove
85076755 |  | -3.5 | -253.75 | Remove
85076756 | 2012-09-11 00:00:00 | -2 | -151.84 | Keep
85076759 |  | -5 | -379.6 | Keep
85076776 |  | -7 | -665 | Keep
85076778 |  | -6.5 | -617.5 | Keep
85076755 | 2012-09-11 00:00:00 | -4 | -290 | Remove
85076778 |  | -1 | -95 | Keep
85076755 | 2012-09-04 00:00:00 | -5 | -362.5 | Remove
85074642 | 2012-08-31 00:00:00 | -5 | -362.5 | Remove
85076752 |  | -5.5 | -418 | Keep
85076755 |  | -25 | -1812.5 | Remove
85076756 | 2012-09-11 00:00:00 | -2 | -151.84 | Keep
85076759 |  | -6 | -455.52 | Keep
85076755 |  | -8 | -580 | Remove
85076755 | 2012-09-07 00:00:00 | -9 | -652.5 | Remove
85074642 |  | -7 | -507.5 | Remove
85076755 |  | -5 | -362.5 | Remove
85076756 |  | -5 | -379.6 | Keep
85076759 |  | -4 | -303.68 | Keep
85076776 |  | -9 | -855 | Keep
85076778 | 2012-09-09 00:00:00 | -1 | -95 | Keep
85074642 | 2012-08-30 00:00:00 | -2 | -145 | Remove
85074643 | 2012-08-30 00:00:00 | -3 | -217.5 | Keep
85074661 | 2012-08-30 00:00:00 | -5 | -400 | Remove
85076749 |  | -7.5 | -600 | Remove
85076754 |  | -12 | -870 | Remove
85074643 |  | -10 | -507.5 | Keep
85074661 | 2012-08-30 00:00:00 | -7 | -560 | Remove
85076749 |  | -78 | -6240 | Remove
85076754 |  | -57 | -4132.5 | Remove
85074643 |  | -12 | -217.5 | Keep
85076749 | 2012-09-10 00:00:00 | -4 | -320 | Remove
85076754 | 2012-09-01 00:00:00 | -3 | -217.5 | Remove
85076778 | 2012-09-10 00:00:00 | -0.5 | -47.5 | Keep
85076755 | 2012-09-11 00:00:00 | -4 | -290 | Remove
85076778 | 2012-09-10 00:00:00 | -0.5 | -47.5 | Keep
85074642 | 2012-08-30 00:00:00 | -1 | -72.5 | Remove
85075950 | 2012-08-31 00:00:00 | -12 | -911.04 | Keep
85075951 |  | -15 | -1138.8 | Keep
85076752 |  | -19.5 | -1482 | Keep
85076755 | 2012-09-03 00:00:00 | -4 | -290 | Remove
85076756 |  | -27 | -2049.84 | Keep
85076759 |  | -30 | -2277.6 | Keep
85076776 | 2012-09-11 00:00:00 | -9 | -855 | Keep
85076778 | 2012-09-11 00:00:00 | -4 | -380 | Keep
85076752 | 2012-09-10 00:00:00 | -4 | -304 | Keep
85076755 |  | -5 | -362.5 | Remove
85076752 | 2012-09-08 00:00:00 | -0.5 | -38 | Keep
85076755 |  | -12 | -870 | Remove
85074642 | 2012-08-30 00:00:00 | -3 | -217.5 | Remove
85076752 |  | -4.5 | -342 | Keep
85076776 |  | -6.5 | -617.5 | Keep
85076759 | 2012-09-05 00:00:00 | -3 | -227.76 | Keep
85076776 | 2012-09-05 00:00:00 | -3 | -285 | Keep
85076752 | 2012-09-09 00:00:00 | -0.5 | -38 | Keep
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96 | Keep
85076752 | 2012-09-09 00:00:00 | -1 | -76 | Keep
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96 | Keep
85076755 | 2012-09-02 00:00:00 | -2 | -145 | Remove
85076756 | 2012-09-04 00:00:00 | -2 | -151.84 | Keep
85076759 | 2012-09-04 00:00:00 | -4 | -303.68 | Keep
85076755 | 2012-09-03 00:00:00 | -1 | -72.5 | Remove
85076778 | 2012-09-08 00:00:00 | -2.5 | -237.5 | Keep
85076755 | 2012-09-03 00:00:00 | -1 | -72.5 | Remove
85076755 | 2012-09-03 00:00:00 | -1 | -72.5 | Remove
85076755 | 2012-09-03 00:00:00 | -1 | -72.5 | Remove
85076776 | 2012-09-01 00:00:00 | -1 | -95 | Keep
85076776 | 2012-09-01 00:00:00 | -1 | -95 | Keep
85075952 | 2012-08-30 00:00:00 | -10.5 | -798 | Remove
85074642 | 2012-08-30 00:00:00 | -1 | -72.5 | Remove
85076778 | 2012-09-09 00:00:00 | -1 | -95 | Keep
85076778 | 2012-09-07 00:00:00 | -0.75 | -71.25 | Keep
85076778 | 2012-09-07 00:00:00 | -0.75 | -71.25 | Keep
85076776 | 2012-09-04 00:00:00 | -0.5 | -47.5 | Keep
85076778 | 2012-09-11 00:00:00 | -1 | -95 | Keep
85076755 |  | -2 | -145 | Remove
85076749 |  | -10 | -800 | Remove
85076752 | 2012-09-06 00:00:00 | -14 | -1064 | Keep
85076778 |  | -15.5 | -1472.5 | Keep
85076778 | 2012-09-09 00:00:00 | -0.5 | -47.5 | Keep
85074642 | 2012-08-30 00:00:00 | -1 | -72.5 | Remove
85076755 |  | -7 | -507.5 | Remove
85076759 | 2012-09-02 00:00:00 | -2 | -151.84 | Keep
85076778 | 2012-09-09 00:00:00 | -2 | -190 | Keep
85076748 | 2012-09-04 00:00:00 | -1 | -58.5 | Remove
85076755 | 2012-09-03 00:00:00 | -1 | -72.5 | Remove
85076756 | 2012-09-01 00:00:00 | -1 | -75.92 | Keep
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96 | Keep
85076756 | 2012-09-01 00:00:00 | -1 | -75.92 | Keep
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96 | Keep
85076756 | 2012-09-01 00:00:00 | -1 | -75.92 | Keep
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96 | Keep
85076778 | 2012-09-08 00:00:00 | -0.5 | -47.5 | Keep
85076756 | 2012-09-01 00:00:00 | -1 | -75.92 | Keep
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96 | Keep
85076778 | 2012-09-08 00:00:00 | -0.5 | -47.5 | Keep
85076756 | 2012-09-05 00:00:00 | -4 | -303.68 | Keep
85076778 | 2012-09-10 00:00:00 | -2 | -190 | Keep
85074646 | 2012-08-31 00:00:00 | -2 | -190 | Keep
85076752 | 2012-09-09 00:00:00 | -1 | -76 | Keep
85076759 | 2012-09-02 00:00:00 | -1 | -75.92 | Keep
85076776 |  | -4 | -380 | Keep
85076778 |  | -3 | -285 | Keep
85076752 | 2012-09-09 00:00:00 | -2 | -152 | Keep
85076778 | 2012-09-07 00:00:00 | -2.5 | -237.5 | Keep
85074646 | 2012-08-31 00:00:00 | -5.5 | -522.5 | Keep
85075950 | 2012-08-30 00:00:00 | -4 | -303.68 | Keep
85076750 | 2012-09-06 00:00:00 | -4 | -251.8 | Keep
85076751 | 2012-09-06 00:00:00 | -4 | -251.8 | Keep
85076776 |  | -7 | -665 | Keep
85076778 |  | -4 | -380 | Keep
85074646 | 2012-08-31 00:00:00 | -0.5 | -47.5 | Keep
85076752 |  | -2 | -152 | Keep
85076756 |  | -2 | -151.84 | Keep
85076776 |  | -3 | -285 | Keep
85076778 | 2012-09-11 00:00:00 | -2.5 | -237.5 | Keep
85074658 | 2012-08-30 00:00:00 | -3 | -188.85 | Remove
85074662 |  | -11.5 | -672.75 | Remove
85074663 | 2012-08-30 00:00:00 | -2 | -125.9 | Keep
85074664 | 2012-08-30 00:00:00 | -6 | -377.7 | Remove
85074666 | 2012-08-30 00:00:00 | -2 | -125.9 | Keep
85074667 | 2012-08-30 00:00:00 | -2 | -125.9 | Keep
85076744 |  | -54 | -3399.33 | Keep
85076745 |  | -38.5 | -2423.59 | Keep
85076746 |  | -59 | -3714.07 | Keep
85076747 |  | -47.5 | -2778.75 | Remove
85076748 |  | -19.5 | -1140.75 | Remove
85076750 |  | -31.5 | -1982.93 | Keep
85076751 |  | -38.5 | -2423.58 | Keep
85076753 |  | -46 | -2691 | Remove
85076752 | 2012-09-05 00:00:00 | -3.5 | -266 | Keep
85076756 | 2012-09-05 00:00:00 | -4 | -303.68 | Keep
85076759 | 2012-09-05 00:00:00 | -2 | -151.84 | Keep
85076776 | 2012-09-05 00:00:00 | -4 | -380 | Keep
85076778 | 2012-09-05 00:00:00 | -3.5 | -332.5 | Keep
85076778 | 2012-09-05 00:00:00 | -1 | -95 | Keep
85072951 | 2012-09-04 00:00:00 | 13 | 1100 | Keep
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96 | Keep
85074642 | 2012-08-30 00:00:00 | 1 | 72.5 | Remove
85074646 | 2012-08-31 00:00:00 | 3.5 | 332.5 | Keep
85074655 | 2012-08-30 00:00:00 | 6 | 351 | Remove
85074658 | 2012-08-30 00:00:00 | 3 | 188.85 | Remove
85074662 |  | 24.5 | 1433.25 | Remove
85074663 | 2012-08-30 00:00:00 | 5 | 314.75 | Keep
85074664 | 2012-08-30 00:00:00 | 6 | 377.7 | Remove
85074666 | 2012-08-30 00:00:00 | 4 | 251.8 | Keep
85074667 | 2012-08-30 00:00:00 | 4 | 251.8 | Keep
85075950 | 2012-08-30 00:00:00 | 2 | 151.84 | Keep
85076744 |  | 32 | 2014.4 | Keep
85076745 |  | 45.5 | 2864.23 | Keep
85076746 |  | 27 | 1699.66 | Keep
85076747 |  | 38.5 | 2252.25 | Remove
85076748 |  | 36 | 2106 | Remove
85076749 |  | 14 | 1120 | Remove
85076750 |  | 36.5 | 2297.69 | Keep
85076751 |  | 41.5 | 2612.45 | Keep
85076752 |  | 26 | 1976 | Keep
85076753 |  | 40.5 | 2369.25 | Remove
85076755 | 2012-09-06 00:00:00 | 2 | 145 | Remove
85076756 |  | 17 | 1290.64 | Keep
85076759 |  | 8.5 | 645.32 | Keep
85076776 |  | 17 | 1615 | Keep
85076778 |  | 28.5 | 2707.5 | Keep
85074642 | 2012-08-31 00:00:00 | 3 | 217.5 | Remove
85074646 | 2012-08-30 00:00:00 | 12.5 | 1187.5 | Keep
85074651 | 2012-08-30 00:00:00 | 14.5 | 1377.5 | Remove
85074662 | 2012-09-11 00:00:00 | 1 | 58.5 | Remove
85075950 | 2012-08-30 00:00:00 | 6 | 455.52 | Keep
85075951 | 2012-08-30 00:00:00 | 10.5 | 797.16 | Keep
85076744 | 2012-09-11 00:00:00 | 1 | 62.95 | Keep
85076746 | 2012-09-11 00:00:00 | 1 | 62.95 | Keep
85076747 | 2012-09-11 00:00:00 | 1 | 58.5 | Remove
85076753 | 2012-09-11 00:00:00 | 1 | 58.5 | Remove
85076755 |  | 3.5 | 253.75 | Remove
85076759 | 2012-09-03 00:00:00 | 3 | 227.76 | Keep
85076776 |  | 6 | 570 | Keep
85076778 |  | 4.5 | 427.5 | Keep
85076755 | 2012-09-11 00:00:00 | 4 | 290 | Remove
85076778 |  | 1 | 95 | Keep
85076755 | 2012-09-04 00:00:00 | 5 | 362.5 | Remove
85074642 | 2012-08-31 00:00:00 | 5 | 362.5 | Remove
85076752 | 2012-09-08 00:00:00 | 4.5 | 342 | Keep
85076755 |  | 25 | 1812.5 | Remove
85076759 | 2012-09-03 00:00:00 | 4 | 303.68 | Keep
85076755 |  | 8 | 580 | Remove
85076755 | 2012-09-07 00:00:00 | 9 | 652.5 | Remove
85074642 |  | 7 | 507.5 | Remove
85076755 |  | 5 | 362.5 | Remove
85076756 |  | 5 | 379.6 | Keep
85076759 |  | 4 | 303.68 | Keep
85076776 |  | 9 | 855 | Keep
85076778 | 2012-09-09 00:00:00 | 1 | 95 | Keep
85074642 | 2012-08-30 00:00:00 | 2 | 145 | Remove
85074661 | 2012-08-30 00:00:00 | 5 | 400 | Remove
85076749 |  | 7.5 | 600 | Remove
85076754 |  | 12 | 870 | Remove
85074643 | 2012-08-30 00:00:00 | 7 | 507.5 | Keep
85074661 | 2012-08-30 00:00:00 | 7 | 560 | Remove
85076749 |  | 78 | 6240 | Remove
85076754 |  | 57 | 4132.5 | Remove
85074643 | 2012-08-30 00:00:00 | 3 | 217.5 | Keep
85076749 | 2012-09-10 00:00:00 | 4 | 320 | Remove
85076754 | 2012-09-01 00:00:00 | 3 | 217.5 | Remove
85076778 | 2012-09-10 00:00:00 | 0.5 | 47.5 | Keep
85076755 | 2012-09-11 00:00:00 | 4 | 290 | Remove
85076778 | 2012-09-10 00:00:00 | 0.5 | 47.5 | Keep
85074642 | 2012-08-30 00:00:00 | 1 | 72.5 | Remove
85075950 | 2012-08-31 00:00:00 | 12 | 911.04 | Keep
85075951 |  | 15 | 1138.8 | Keep
85076752 | 2012-09-07 00:00:00 | 13.5 | 1026 | Keep
85076755 | 2012-09-03 00:00:00 | 4 | 290 | Remove
85076756 |  | 21 | 1594.32 | Keep
85076759 |  | 24 | 1822.08 | Keep
85076752 | 2012-09-10 00:00:00 | 4 | 304 | Keep
85076755 |  | 5 | 362.5 | Remove
85076752 | 2012-09-08 00:00:00 | 0.5 | 38 | Keep
85076755 |  | 12 | 870 | Remove
85074642 | 2012-08-30 00:00:00 | 3 | 217.5 | Remove
85076752 | 2012-09-10 00:00:00 | 2 | 152 | Keep
85076776 |  | 6.5 | 617.5 | Keep
85076759 | 2012-09-05 00:00:00 | 3 | 227.76 | Keep
85076776 | 2012-09-05 00:00:00 | 3 | 285 | Keep
85076752 | 2012-09-09 00:00:00 | 0.5 | 38 | Keep
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96 | Keep
85076752 | 2012-09-09 00:00:00 | 1 | 76 | Keep
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96 | Keep
85076755 | 2012-09-02 00:00:00 | 2 | 145 | Remove
85076756 | 2012-09-04 00:00:00 | 2 | 151.84 | Keep
85076759 | 2012-09-04 00:00:00 | 4 | 303.68 | Keep
85076755 | 2012-09-03 00:00:00 | 1 | 72.5 | Remove
85076778 | 2012-09-08 00:00:00 | 2.5 | 237.5 | Keep
85076755 | 2012-09-03 00:00:00 | 1 | 72.5 | Remove
85076755 | 2012-09-03 00:00:00 | 1 | 72.5 | Remove
85076755 | 2012-09-03 00:00:00 | 1 | 72.5 | Remove
85076776 | 2012-09-01 00:00:00 | 1 | 95 | Keep
85076776 | 2012-09-01 00:00:00 | 1 | 95 | Keep
85075952 | 2012-08-30 00:00:00 | 10.5 | 798 | Remove
85074642 | 2012-08-30 00:00:00 | 1 | 72.5 | Remove
85076778 | 2012-09-09 00:00:00 | 1 | 95 | Keep
85076778 | 2012-09-07 00:00:00 | 0.75 | 71.25 | Keep
85076778 | 2012-09-07 00:00:00 | 0.75 | 71.25 | Keep
85076776 | 2012-09-04 00:00:00 | 0.5 | 47.5 | Keep
85076755 |  | 2 | 145 | Remove
85076749 |  | 10 | 800 | Remove
85076752 | 2012-09-06 00:00:00 | 14 | 1064 | Keep
85076778 |  | 15.5 | 1472.5 | Keep
85076778 | 2012-09-09 00:00:00 | 0.5 | 47.5 | Keep
85074642 | 2012-08-30 00:00:00 | 1 | 72.5 | Remove
85076755 |  | 7 | 507.5 | Remove
85076759 | 2012-09-02 00:00:00 | 2 | 151.84 | Keep
85076778 | 2012-09-09 00:00:00 | 2 | 190 | Keep
85076748 | 2012-09-04 00:00:00 | 1 | 58.5 | Remove
85076755 | 2012-09-03 00:00:00 | 1 | 72.5 | Remove
85076756 | 2012-09-01 00:00:00 | 1 | 75.92 | Keep
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96 | Keep
85076756 | 2012-09-01 00:00:00 | 1 | 75.92 | Keep
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96 | Keep
85076756 | 2012-09-01 00:00:00 | 1 | 75.92 | Keep
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96 | Keep
85076778 | 2012-09-08 00:00:00 | 0.5 | 47.5 | Keep
85076756 | 2012-09-01 00:00:00 | 1 | 75.92 | Keep
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96 | Keep
85076778 | 2012-09-08 00:00:00 | 0.5 | 47.5 | Keep
85076756 | 2012-09-05 00:00:00 | 4 | 303.68 | Keep
85076778 | 2012-09-10 00:00:00 | 2 | 190 | Keep
85076752 | 2012-09-09 00:00:00 | 1 | 76 | Keep
85076759 | 2012-09-02 00:00:00 | 1 | 75.92 | Keep
85076776 |  | 4 | 380 | Keep
85076778 |  | 3 | 285 | Keep
85076752 | 2012-09-09 00:00:00 | 2 | 152 | Keep
85076778 | 2012-09-07 00:00:00 | 2.5 | 237.5 | Keep
85075950 | 2012-08-30 00:00:00 | 4 | 303.68 | Keep
85076750 | 2012-09-06 00:00:00 | 4 | 251.8 | Keep
85076751 | 2012-09-06 00:00:00 | 4 | 251.8 | Keep
85076776 |  | 7 | 665 | Keep
85076778 |  | 4 | 380 | Keep
85076752 |  | 1.5 | 114 | Keep
85076756 |  | 2 | 151.84 | Keep
85076776 |  | 3 | 285 | Keep
85074658 | 2012-08-30 00:00:00 | 3 | 188.85 | Remove
85074662 |  | 11.5 | 672.75 | Remove
85074663 | 2012-08-30 00:00:00 | 2 | 125.9 | Keep
85074664 | 2012-08-30 00:00:00 | 6 | 377.7 | Remove
85074666 | 2012-08-30 00:00:00 | 2 | 125.9 | Keep
85074667 | 2012-08-30 00:00:00 | 2 | 125.9 | Keep
85076744 |  | 54 | 3399.33 | Keep
85076745 |  | 38.5 | 2423.59 | Keep
85076746 |  | 59 | 3714.07 | Keep
85076747 |  | 47.5 | 2778.75 | Remove
85076748 |  | 19.5 | 1140.75 | Remove
85076750 |  | 31.5 | 1982.93 | Keep
85076751 |  | 38.5 | 2423.58 | Keep
85076753 |  | 46 | 2691 | Remove
85076752 | 2012-09-05 00:00:00 | 3.5 | 266 | Keep
85076756 | 2012-09-05 00:00:00 | 4 | 303.68 | Keep
85076759 | 2012-09-05 00:00:00 | 2 | 151.84 | Keep
85076776 | 2012-09-05 00:00:00 | 4 | 380 | Keep
85076778 | 2012-09-05 00:00:00 | 3.5 | 332.5 | Keep
85076778 | 2012-09-05 00:00:00 | 1 | 95 | Keep
85072951 | 2012-09-28 00:00:00 | 0 | 140 | Keep
85072951 | 2012-09-28 00:00:00 | 0 | 195 | Keep
85075951 | 2012-09-28 00:00:00 | 0 | 0.01 | Keep
85072951 | 2012-09-28 00:00:00 | 0 | -45 | Keep
85072951 | 2012-09-28 00:00:00 | 0 | 260 | Keep
85075951 | 2012-09-28 00:00:00 | 0 | 0.01 | Keep