Looking for a solution using excel-
Example: Imagine that you have a reconciliation with 100s or 1000s of debits
or credits. You also have the offsetting debit or credit, which is one item.
You know that the one debit or credit equals some offsetting combination of
debits or credits.
Instead of going up and down one column (in a trial and error fashion that can
take a long time) to find that combination of debits or credits that equals
your single item offset, is there an excel function that can be used to hi-lite
one column and have it search/find various combinations that equal the offset?
Can some nice person please review my file and insert some formula guiding how to offset.After offsetting left over value should be
17,671.92
Thanks Heaps
Rahul
Example: Imagine that you have a reconciliation with 100s or 1000s of debits
or credits. You also have the offsetting debit or credit, which is one item.
You know that the one debit or credit equals some offsetting combination of
debits or credits.
Instead of going up and down one column (in a trial and error fashion that can
take a long time) to find that combination of debits or credits that equals
your single item offset, is there an excel function that can be used to hi-lite
one column and have it search/find various combinations that equal the offset?
Can some nice person please review my file and insert some formula guiding how to offset.After offsetting left over value should be
17,671.92
Thanks Heaps
Rahul