vimal01234
New Member
- Joined
- Oct 8, 2014
- Messages
- 6
I am new to Macros and having a little trouble in identifying a solution
I have a row which contains more than 500 items/numbers in postive as well as in negative. these rows match with each other and net to zero just like reconciliation, however, there may be more than 4 negatives which make up a positive amount or vice versa to net this to zero. for eg: if there is an amount of (126.50)
this can be zeroised with 20+6.25+0.25+100
I am looking for a macro which can identify these amounts which net to zero with each other and exclude remaining amounts which dont get zero.
Any ideas?
I have a row which contains more than 500 items/numbers in postive as well as in negative. these rows match with each other and net to zero just like reconciliation, however, there may be more than 4 negatives which make up a positive amount or vice versa to net this to zero. for eg: if there is an amount of (126.50)
this can be zeroised with 20+6.25+0.25+100
I am looking for a macro which can identify these amounts which net to zero with each other and exclude remaining amounts which dont get zero.
Any ideas?
