Results 1 to 1 of 1

Branch Reconciliation

This is a discussion on Branch Reconciliation within the Excel Questions forums, part of the Question Forums category; COMPANY A COMPANY Z DOC DOC NO DATE DEBIT CREDIT DOC DOC NO DATE DEBIT CREDIT A B A B ...

  1. #1
    New Member
    Join Date
    Mar 2010
    Location
    DUBAI, U.A.E.
    Posts
    3

    Default Branch Reconciliation

    COMPANY ACOMPANY Z

    DOCDOC NODATEDEBIT
    CREDIT
    DOCDOC NODATEDEBITCREDIT




    AB


    AB

    UP0/000182/1/2010- 240.00 US0/000011/1/201042.00 -

    UP0/000192/1/2010- 42.00 US0/000041/1/2010240.00 -

    UP0/000202/1/2010- 76.00 US0/000031/1/201042.00 -

    UP0/000232/1/2010- 42.00 UP0/000022/1/2010- 667.00

    US0/000232/1/2010667.00 - UP0/000032/1/2010- 535.00

    UP0/000252/1/2010- 38.00 UP0/000042/1/2010- 200.00

    UP0/000262/1/2010- 106.00 US0/000062/1/201064.00 -

    US0/000112/1/2010438.00 - WJ0/000012/1/2010- 1.00

    US0/000202/1/2010200.00 - US0/000082/1/2010206.00 -

    US0/000212/1/2010536.00 - US0/000092/1/201051.00 -

























    I want to have look up function as:


















    1Debit(A) of company A, should match with Credit(B) of company Z


    Then I will filter records only matching in both company and then I shall delete it to get the unmatched records.












    Please I badly need a help.

    {moderator note:email address removed}








    Last edited by Jon von der Heyden; Jan 18th, 2011 at 10:05 AM. Reason: email address removed

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com