Matching positive and negative values

[Ressa91]

Hi everyone

I've been given a task where I need to reconcile accounts to find the imbalances. I need to match "pair" positive and negative values that adds up to zero.

I'm looking for a formula that will highlight and move the matches to another sheet, so that I'm only left with duplicates or values that doesn't add up to zero.

See example below

Is this something someone here can help me with if possible? The data set is huge and doing manually is time consuming.

Appreciative of the feedback!
Thank you,

 

[awoohaw]

why is the value in the top row Yellow, and why are the bottom two rows not yellow?

 

[Ressa91]

why is the value in the top row Yellow, and why are the bottom two rows not yellow?

everything marked in yellow is the positives and negatives that adds up to zero. the bottom two that isn't highlighted is duplicates as you can see by the reference in column B. I'm looking for a formula that can match the positives and negatives that adds up to zero because doing it manually is very time consuming as per my example (which is 3 different examples of how it adds up to zero).

 

[awoohaw]

everything marked in yellow is the positives and negatives that adds up to zero. the bottom two that isn't highlighted is duplicates as you can see by the reference in column B. I'm looking for a formula that can match the positives and negatives that adds up to zero because doing it manually is very time consuming as per my example (which is 3 different examples of how it adds up to zero).

OKay, its beyond my thinking. Maybe someone else will chime in.

 

[Akuini]

The data set is huge and doing manually is time consuming.

I'm looking for a formula that can match the positives and negatives

How about a macro?
I've written a macro to match positive and negative numbers.

 

[Ressa91]

How about a macro?
I've written a macro to match positive and negative numbers.

Yes that would be great
Can the macro match positive and negative numbers that aren't identical.
for example

 

[Akuini]

Can the macro match positive and negative numbers that aren't identical.

No, it must be 1 number against 1 number.

 

[Ressa91]

No, it must be 1 number against 1 number.

Could the macro maybe be adjusted to use column B as a "reference" to matching non identical values that adds up to zero?

 

[Akuini]

Could the macro maybe be adjusted to use column B as a "reference" to matching non identical values that adds up to zero?

What do you mean? Could you show us an example?

 

[Ressa91]

What do you mean? Could you show us an example?

In the example below I used column B,C,D to match the values in Column E.

Hope it makes sense what I'm trying to say