Excel VBA to match positive and negative transactions

R

Ron099

Joined
Dec 30, 2017
Messages
1
Reaction score
0
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!
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Updating inventory levels 0
match a positive and negative amount in excel 2010 3
Access MS Access Required Fields 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel - Match positive and negative numbers 9
Access Command button to look up and copy data from a query to a table 0
Access Negative Percentages in Report in Access 2007 0
Reallocate array cells value from positive to negative 0

Back
Top