• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reconcile debits & credits using Solver

rahuln

New Member
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
 

Attachments

Top