Search results

Please see the data below: # Unit bar Code Amount 1. AAB Mac1 2.75 2. AAB Mac1 -2.75 3. AAB Mac1 1.24 4. AAC Mac3 35.00 5. AAC Mac3 -20.00 6. AAC Mac3 20.00 7. AAD Mac3 16.11 8. AAC Mac2 11.00 9. AAC Mac2 -11.00 10 AAC Mac3 12.05 11 AAF Mac3 -12.05 12 AAD Mac3 -16.11 13 AAC Mac4 35.00 I...

What do you suggest then? Do you need some data to rework this for me? The "where" is to match the concatenated phrase...and I would like to know how to test them separate rather than as a concatenated phrase to...also I used the abs so I can compare the concatenated phrase for both the positive...

I have a similar problem like the above but in my case I have about 70 columns but would like to remove any two rows that sum to zero (based on two columns) if the column "Units" are the same for the same "Bar code" thus to say "for the same 'Units' for any two lines, check to see if their...