Matching Values to Zero
I have sorted a spreadsheet by absolute value to match the exact
positives and negatives together. But the information is too large. So
I created nested if statements incorporating "and" and "or" statements
to help match the positive values and negative values.
Here is a sample (x's mean a row matches with another row):
37 10650-4 1,100.90 1100.9_37 x
37 10650-4 (1,100.90) 1100.9_37 x
42 10650-4 (1,100.90) 1100.9_42 x
5 10650-4 1,100.90 1100.9_50 x
5 10650-4 1,100.90 1100.9_50
As you can see, these match correctly and show the last line +1,100.90
does not have a match. This works great, throughout some of the
spreadsheet, but not everything.
Can anyone help? I can email you the spreadsheet.
Thanks...
|