Excel VBA to match positive and negative transactions

[Ron099]

Hi!

I hope someone can assist me on this one.

It’s possible to write a vba code that can
match up multiple positive transactions against multiple negative transactions that offset to zero?

Thanks!

 

[AmjiBhai]

For such a requirement excel and VBA offer ABS function which converts -ve to +ve, thereafter you can compare the two numbers.

For example column A has all +ve numbers
A
300
400
800

Column B has all -ve numbers

B
-300
-400
-800

In Column C.....Now lets compare them using ABS Function

=A1-ABS(B1)
.....the answer is 0 ...means no difference.

 

[aeqquus]

add a column in your data and then put a formula for ABS() absolute value. Sort on absolute value then match rows. A VBA routine to do this is pointless since there will be multiple cells with same absolute value. This sounds like some sort of reconciliation routine. The issue is multiple rows with same absolute values. VBA would need some other identifier to differentiate similar rows.

 

[Sharman2]

How we can find the offset value like -2,-2,4
Is their any formula to solve this..