• 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.

Matching contra bank entries

A

Amit_KK

New Member
Hello friends. I have a problem and need your guidance on it. Please help.

I have the multiple bank statements in an Excel sheet one below the other. For reporting I want to identify contra entries. I want to match an amount debited from one account with the credit in some other account reflected on the same day with the same amount.

How to do it. Please share if possible I want to colour matching entries.
 

Amit_KK​

As You've asked with Your previous thread,
please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially
How to get the Best Results at Chandoo.org
  • Use Relevant words in the Title and in the tag Box, This will aid future searches.
  • When drafting a question, try and lay out the question in a clear and concise way.
  • Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
  • Don't leave out information more info is better
  • For the best/fastest results, Upload a Sample File
 
You must log in or register to reply here.
Back
Top